removefilters function for 2 slicers

[CloudMonkey]

Hi,

I have a 2 slicers - one for areas and one for regions. I need to a measure to show total sales for all areas and regions. I tried the below formula but the error message says I can't refer to more than one table within the REMOVEFILTERS function. Please can someone tell me how to resolve?

Sales (All areas and regions) = calculate([Sales],REMOVEFILTERS(areas[AreaName],regions[RegionName]))

Many thanks,

CM

[CloudMonkey]

Thank you both! 🙂

[PaulDBrown]

@CloudMonkey 

Use the ALL function instead, referencing the fact table you are calculating sales on. For example:

Measure = CALCULATE(SUM(Table[sales]), ALL(Table))

[mahoneypat · Accepted solution]

You can't refer to columns in different tables in REMOVEFILTERS or ALL.  Make a separate REMOVEFILTERS for each column).

Regards,

Pat