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
GilbertQ's avatar
GilbertQ
Super User
8 years ago

Hi vickyprudhvi

 

If you run the measures seperately do they run quickly?

 

I have not experienced any performance issues when using the Dynamic Measures before (Mostly been done where the data was imported into the Power BI Desktop file)

  • vickyprudhvi's avatar
    vickyprudhvi
    Helper IV
    8 years ago

    GilbertQ

    If I use this measure against  8k rows it is fast but wen I use this measure against 20Mill it is very slow.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      8 years ago

      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.

    • GilbertQ's avatar
      GilbertQ
      Super User
      8 years ago

      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.

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