Changing filtering sequence in Power BI

[rswami_4]

I have a table that looks like this:

MyTable
MyColumn1	MyColumn2	MyColumn3
10-Aug	Value 1	X
10-Aug	Value 2
10-Aug	Value 1	X
11-Aug	Value 1
11-Aug	Value 2	X
12-Aug	Value 1	X

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 · Accepted solution]

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.