Matrix Sub Total %

DAX DAX Calculations
1

OK, I’m brushing up on my skills, and need a little guidance to create a Measure to add to a Matrix…

Using the eDNA Practice Dataset, how do I show a % of sales per Full Name against Customer Name?.
Using a Matrix visual as per below: (on the left is Excel of what I want to achieve, column D, on the right is the matrix).

Screenshot 2021-03-01 113721
Screenshot 2021-03-01 1137211018×699 73.5 KB

2

Hello @marcster_uk,

Thank You for posting your query onto the Forum.

You can use the below formula for the reference =

% Of Total Sales = 
DIVIDE( [Total Sales] , 
    CALCULATE( [Total Sales] , 
        ALL( Regions[City] ) ) ,
    BLANK() )

Result
Result402×736 27.8 KB

Note: The naming convention might be different in your file so incorporate it accordingly.

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

Thanks and Warm Regards,
Harsh

3

Thanks @Harsh :slight_smile:

4

Hello @marcster_uk,

You’re Welcome.

Thanks and Warm Regards,
Harsh