Forum Discussion
amandabus21
Helper V
Helper VCOnditonal 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]
)
)
amandabus21Helper V
Helper VThis gave blank values.
If i remove ""Sum" from Variable difference, the whole table goes blank.
tamerj1
Community Champion
Community ChampionThis is a new Measure which calculates based on the original Calculated Column.
- amandabus21
Yes, I created as a new measure and added to the table. Its still blank.