DAX Filter Forumla

amandabus21 — Fri, 04 Aug 2023 21:51:42 GMT

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,

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

Re: DAX Filter Forumla

Jihwan_Kim — Sat, 05 Aug 2023 09:29:33 GMT

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.