Forum Discussion
Dax Measure Performance
Hi , We have 21mil rows tables and corrected to PowertBI Desktop using Direct Query method. We have created a parameter table with 7 Measure names and created a measure using swtich case to show dif...
Hi vickyprudhvi
That would indicate that the measure is not as fast as it could be. I would suggest looking at ways to improve the measure so that it returns the data faster.
Once that is done, then I am sure that the SWITCH measure would work well.
GilbertQ and Greg_Deckler
Sorry - Measure I meant here is Switch case measure.
all the measures used in the switch case are simple sum() and countrows.
independently all measures work pretty good.
I am using the switch case measure across a time period for a year (Trending Chart).