Denominator that removes certain context filters but keeps all visual, page and report filters

[Anonymous]

Hello,

I would like to create a denominator for a drill-down table that drills down on a product's Brand, SubBrand, and then Item. I would need a denominator that can ignore the context filter when drilling down to the Item, but retaining the context filter from the Brand. 

Then, I would also like the visual, page and report filters to still work on the Brand, the SubBrand and the Item for both the numerator and the denominator. This functionality is currently being overwritten in my DAX using the ALL() function. Is there any alternative I could try that would allow me to continue to remove context filters from the Item in my drilldown but still keep the Item filters done by the user in the visual, page and report filters?

Current DAX example:

CALCULATE(

[Sales], 

filter(

ALL(

'Product'[Brand],

'Product'[Sub Brand],

'Product'[Product Name],

)))

[d_gosbell · Accepted solution]

I think the following approach should do what you want. It will give the same value for every row, but still reflects any filters the user applies

CALCULATE(
[Sales], 
ALLSELECTED('Product'[Brand]),
ALLSELECTED('Product'[Sub Brand]),
ALLSELECTED('Product'[Product Name])
)