Percent of Totals by month

DAX DAX Calculations
1

I need the % of total by each category by month, not % of grand total. The results that a stacked column chart gives me. For Jan, Blue should be 25%, Green 25%, and Red 50%.

Month

Sample.pbix (63.1 KB)

2

Hello @Usates,

Thank You for posting your query onto the Forum.

To achieve the results based on the scenario that you’ve specified. Below is the measure alongwith the screenshot of the final results provided for the reference -

% of Total Amount = 
DIVIDE(
    [Total Amount] , 
    CALCULATE( [Total Amount] , 
        ALLEXCEPT( 'Date' , 'Date'[Month] ) ) , 
    0 )

Final Results
Final Results1191×342 17.9 KB

I’m also attaching the working of the PBIX file for the reference purposes.

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

Thanks and Warm Regards,
Harsh

Sample - Harsh.pbix (63.2 KB)

1 Like