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
Ok thanks for letting me know.
I am not sure why the SWITCH is so slow. My only thinking is possibly because it is built ontop of the DirectQuery connection?
I dont think direct query will effect a measure performance so much . I woould like to know if there is any other way fo achieving this functionality without using Switch case of hasonefilter function