Forum Discussion
Solved
COnditonal Column
How can I change this formula so that it only calculates if the previous Equipment Key does not equal the next Equipment Key. It then should be 0. Variable Difference = VAR curr = ...
Please try
MeasureDifference =
VAR FirstSelectedDate =
CALCULATE (
MIN ( 'PM On Time Performance Bus PM-BI-002 (2)'[Completion Date.Completion Date Level 01] ),
ALLSELECTED (),
VALUES ( 'PM On Time Performance Bus PM-BI-002 (2)'[Equipment.Equipment Level 01.Key] )
)
RETURN
SUMX (
'PM On Time Performance Bus PM-BI-002 (2)',
IF (
'PM On Time Performance Bus PM-BI-002 (2)'[Completion Date.Completion Date Level 01] = FirstSelectedDate,
0,
'PM On Time Performance Bus PM-BI-002 (2)'[Variable Difference]
)
)
This gave blank values.
If i remove ""Sum" from Variable difference, the whole table goes blank.
This is a new Measure which calculates based on the original Calculated Column.
Yes, I created as a new measure and added to the table. Its still blank.