Total by Customer when If statement used

DAX DAX Calculations
2

Hello @AliB,

Thank You for posting your query onto the Forum.

To fix the totals you just need to write a small measure and you’ll see that all the visuals will get fixed and will start reflecting correct grand totals. Below is the measure alongwith the screenshot of the final results provided for the reference -

Total Forecast - Totals = 
SUMX(
    SUMMARIZE(
        ContractDataTest , 
        ContractDataTest[new_contractno] , 
        ContractDataTest[Forecast Out] , 
        ContractDataTest[Forecast?] , 
        ContractDataTest[Forecast Month] , 
        "@Totals" , 
        [Total Forecast] ) , 
    [@Totals]
)

Final Results
Final Results1415×710 47.1 KB

I’m also attaching the working of the PBIX file as well as providing a link below of the post which one of our expert had created which specifically addresses this type of issues.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Note: In order to view the entire post, please click onto the link and not onto the “expand/collapse” button.

Thanks and Warm Regards,
Harsh

Forecasting Test - Upload - Harsh.pbix (195.7 KB)

1 Like