Forum Discussion

amandabus21's avatar
amandabus21
Helper V
3 years ago

Filter Help

Have this formula, but when I insert a slicer " Bus Equipment Key" to pick one, the formula just zeros out. 

 

Difference # =
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]
)
)

1 Reply

  • Wilson_'s avatar
    Wilson_
    Memorable Member
    3 years ago

    Hi amandabus21,

     

    Any information at all about your data and/or data model would probably be helpful. This post by Greg Deckler might be able to give you some pointers. 🙂