Forum Discussion

vickyprudhvi's avatar
vickyprudhvi
Helper IV
8 years ago

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...
Need Help
vickyprudhvi's avatar
vickyprudhvi
Helper IV
8 years ago

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).

GilbertQ's avatar
GilbertQ
Super User
8 years ago

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?

  • vickyprudhvi's avatar
    vickyprudhvi
    Helper IV
    8 years ago

    GilbertQ

    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