Compare measure by categories

[HoaiNamNguyen]

I have a table as below. I need to calculate metric 1 by Employee, by ASM and by region so I use REMOVEFILTERS:  

- Metric 1 ASM = CALCULATE([Metric 1], REMOVEFILTERS(DI_Employees[Employee]))

- Metric 1 Region = CALCULATE([Metric 1], REMOVEFILTERS(DI_Locations[ASM]), REMOVEFILTERS(DI_Employees[Employee))

But using REMOVEFILTERS makes my table slow and sometimes it's unable to load. 

Is there any alternative method to calculate a measure by different categories? 

Thanksssss

[amitchandak · Accepted solution]

@HoaiNamNguyen , you can use all, but i doubt it will much difference

Metric 1 Region = CALCULATE([Metric 1], all(DI_Locations[ASM]), all(DI_Employees[Employee))

[v-shex-msft · Accepted solution]

Hi @HoaiNamNguyen,

I'd liek to sugget you try to use ALL functions with dax formula instead of REMOVEFILTERS:

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

BTW, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@HoaiNamNguyen , you can use all, but i doubt it will much difference

Metric 1 Region = CALCULATE([Metric 1], all(DI_Locations[ASM]), all(DI_Employees[Employee))