Filter Help

[amandabus21]

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]

)

)

[Wilson_]

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. 🙂