Forum Discussion

rswami_4's avatar
rswami_4
Helper I
10 years ago
Solved

Changing filtering sequence in Power BI

I have a table that looks like this:

 

MyTable  
MyColumn1MyColumn2MyColumn3
10-AugValue 1X
10-AugValue 2 
10-AugValue 1X
11-AugValue 1 
11-AugValue 2X
12-AugValue 1X

 

I have a slicer on MyColumn2 (contains two values - Value 1 and Value 2)

 

I have a calculated column that looks like:

 

MyColumn 4 = COUNTROWS(
FILTER('MyTable' ,
 'MyTable'[MyColumn3] = "X" && 'MyTable'[MyColumn1] <= earlier('MyTable'[MyColumn1])
)
)

 

I need the slicer filter (on MyColumn2) to apply before the DAX Filter (MyColumn3) applies.  Otherwise the results are very different.  How can I make it happen?

  • jahida's avatar
    jahida
    10 years ago

    Using columns, it's not possible, since PowerBI evaluates columns once at refresh, not live. Consider using measures instead. In this case, I think you could just replace the "earlier" with "MAX", wrap the first instance of 'MyTable' with an ALL(), and use exactly the same formula as a measure.

1 Reply

  • jahida's avatar
    jahida
    Impactful Individual
    10 years ago

    Using columns, it's not possible, since PowerBI evaluates columns once at refresh, not live. Consider using measures instead. In this case, I think you could just replace the "earlier" with "MAX", wrap the first instance of 'MyTable' with an ALL(), and use exactly the same formula as a measure.