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...
If I use this measure against 8k rows it is fast but wen I use this measure against 20Mill it is very slow.
Are you certain that it is this SWITCH statement that is running slow versus the actual measures that are being displayed. I think that was what GilbertQ was asking. I tend to agree with him, my suspicion would be that a simple SWITCH statement shouldn't slow things down.