Forum Discussion

zaza's avatar
zaza
Resolver III
5 years ago

Optimizing DAX Measure

I have the following measure whihc works perfectly. However my dataset grew from 2 million rows to 42 million rows and Now this measure takes way too much to load, sometimes some visuals where this i...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

zaza 

I have some DAX Performance Tuning articles here:

These are also good articles:

Sorry for the link spam but it's a broad topic and the information you have provided is limited. Will try to take a closer look at the formula. Can you provide PBIX file or sample source data?

  • zaza's avatar
    zaza
    Resolver III
    5 years ago

    CNENFRNL This would not work as the ABS calculation will not return the correct values. I did try to see and the performance is just slightly better. I realize the issue is with the SUMMARIZE function and I need to do this without using SUMMARIZE.

     

    Greg_Deckler  I read trough the links you provided and I am already doing everything as optimally as possible. I abstracted out the main calculation that is causing the issue into a simple example: PowerBI Absolute Value.pbix 

     

    The calculated measure returns the same result as the ABS function except for the totals. As you can see in the totals the absolute values for each category is summed up. 

    Category Absolute = 
    VAR __table = 
        SUMMARIZE ( 
            'Table',
            'Table'[Category],
            "Absolute", ABS ( SUM ( 'Table'[Value] ) ) 
        )

    RETURN SUMX ( __table, [Absolute] )

    Can I do this somehow without using SUMMARIZE ?