Matrix Totals with Switch measure and ISINSCOPE

DAX DAX Calculations
2

Hello @DeanJ,

Thank You for posting your query onto the Forum.

To fix/achieve the results of the “Grand Totals” just write the smal simple formula as provided below -

Budget Switch - Totals = 
SUMX(
    SUMMARIZE(
        Budget, 
        Budget[Product Line] , 
        Budget[Department] , 
        "@Totals" , 
        [Budget Switch] + [PL Budget] ) ,
    [@Totals]
)

Below is the screenshot of the results provided for the reference.

Results

I’m also attaching the working of the PBIX file for the reference as well as providing the link of the post below which was created by our expert Greg 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: To view the entire post, please click onto the link and not onto the “expand/collapse” button.

Thanks and Warm Regards,
Harsh

Matrix Totals Test - Harsh.pbix (31.6 KB)

1 Like