Measures Total doesn't work

DAX DAX Calculations
2

Hello @npower,

Thank You for posting your query onto the Forum.

Below are the mesures alongwith the screenshot of the final results provided for the reference -

YN 0.5% - Totals = 
SUMX(
    SUMMARIZE(
        Tlog , 
        Tlog[Site] , 
        "@Totals" , 
        [YN 0.5%] ) , 
    [@Totals] )

Value Disc 0.5% - Totals = 
SUMX(
    SUMMARIZE(
        Tlog , 
        Tlog[Site] , 
        "@Totals" , 
        [Value Disc 0.5%] ) , 
    [@Totals] )

Final Results
Final Results1714×961 92.8 KB

I’m also attaching the working of the PBIX file alongwith the link of the post provided below for the reference which is being created by our in-house expert which specifically addresses this type of issue.

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

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

Instacart1 - Harsh.pbix (14.8 MB)

1 Like