Slicer Application Order in Dax

[leahschneider]

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.

[FreemanZ]

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])

) 

[leahschneider]

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