DAX Filter Forumla

[amandabus21]

Hello,

I have this DAX formula that works fine, however when I try to put a slicer on the page and filter by "

[Equipment.Equipment Level 01.Key]" it stops working correctly.

 Is there a way I can make it work on its own and with a slicer.

Difference:

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]

)

) 

Example) See Bus 203, working fine.

 With the slicer selected, it is not working.

[Jihwan_Kim]

Hi,

I am not sure how your datamodel looks like, but instead of using ALLSELECTED, try using ALL in the measure.

Because ALLSELECTED DAX function respects the filter context that is outside of the visualization that you try to implement.