Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
Oct 16, 2024
Solved

Dax measures total mismatch in visual level

Hi Team,   I have below dax measures as follows:   Forecast - Target Units_1 = VAR _DailyUnits = [Target consumption per day_1] RETURN SUMX(Points, SUMX(Calendar_, IF(ISBLANK([Actual Units])...
admin
BI & Data Analysis
Charting
copilot in excel
developer
excel
Excel for web
Excel on Mac
Excel on mobile
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 16, 2024

Excellove15 

Variable is not needed in that case

SUMX (
    Points,
    SUMX (
        Calendar_,
        IF ( ISBLANK ( [Actual Units] ), [Target consumption per day_1] )
    )
)

works

Excellove15's avatar
Excellove15
Iron Contributor
Oct 17, 2024

Hi SergeiBaklan

 

Thanks for your amazing solution sir!😊

This returns the correct results as below:

 

When I keep only the top(high) level filter (i.e) DBName, this new measure takes long time to run & causes performance issues as below:

 

When i ran this query in dax studio, it was taking long time to run:

 

I think if function inside SUMX function is causing the performance issues especially when our data has millions of rows.

But I am struggling to resolve it. 

 

Please advise!

PFA file here with new measure https://1drv.ms/u/c/cfada767f73d87ed/Ea0TIy07Jv9NiL0z6qXUGDQBlicV4y_m8qc5lOou8yp2MA?e=H5aZgu

 

Thanks in advance!

SergeiBaklan 

 

Resources