Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 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
Solved! Go to 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))
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
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
@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))