topic Re: Slicer Application Order in Dax in DAX Commands and Tips

Slicer Application Order in Dax

leahschneider — Thu, 09 Mar 2023 16:33:55 GMT

Is there a way to change the order in which a slicer acts on a DAX equation? For example I want to see a total sales amount for all products that sold more than 100 units. I have a slicer on store. When the slicer shows one store, the DAX equation of CALCULATE(SUM(Sales), Quantity > 100) would show the total sales in that store for each product that sold more than 100 units in that store. The slicer is applied before the calculate. What I'd like to do is to show the total sales in that store for each product that sold more than 100 units in total (not in the selected store). The slicer is applied after the quantity calculation but before the sum.

Re: Slicer Application Order in Dax

FreemanZ — Thu, 09 Mar 2023 19:23:04 GMT

hi leahschneider

interesting and legitimate requirement.

i am afraid not, but you can use ALL to ignore the store context, try like:

CALCULATE(

SUM(Sales),

Quantity > 100,

ALL(TableName[Store])

)

Re: Slicer Application Order in Dax

leahschneider — Mon, 13 Mar 2023 13:37:08 GMT

As far as I can tell, that will remove the store context entirely which is not what I'd like to do.