Calculate measure from another measure
I'm try to create a measure that uses a condition from another measure. Is this possible? Ex. MeasureB:=IF([MeasureA]>0, [MeasureA], blank()). When this calculates, the grand totals are incorrect.
March 26th, 2015 1:54pm
Maybe you to check if your MeasureA is correct on the grand totals for the same filter context used for your MeasureB
And maybe you have to consider to wrap calculate around [M...A] in the expression for [M...B]
Maybe a simpliefied PowerPivot Model would be helpful
- Proposed as answer by Ed Price - MSFTMicrosoft employee, Owner Thursday, April 02, 2015 5:49 PM
Free Windows Admin Tool Kit Click here and download it now
March 26th, 2015 4:41pm
Hi Brittney2013,
Is this still an issue?
April 18th, 2015 8:45pm