Market Share Calculation

DAX DAX Calculations
4

Hello @HariGanesan,

Well since there’s no presence of the PBIX file, I’m using my judgement based on the data which you’ve provided in the screenshot and providing the solution.

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

1). Scenario 1:- Each Brand is divided by the Overall Total Sales -

% Brand Share - Dollar Sales = 
DIVIDE( 
    SUM( Data[Dollar Sales] ) , 
    CALCULATE( SUM( Data[Dollar Sales] ) , 
        ALLSELECTED( Data ) ) ,
    0 )

2). Scenario 2:- Each Brand is divided by the total from their respective Category -

% Category Share - Dollar Sales = 
DIVIDE( 
    SUM( Data[Dollar Sales] ) , 
    CALCULATE( SUM( Data[Dollar Sales] ) , 
        ALLEXCEPT( Data , Data[Category] ) , 
        VALUES( Data[Category] ) ) ,
    0 )

Same method is also applicable for the calculation of Volume Sales.

Final Results
Final Results1541×295 16.2 KB

I’m also attaching the working of the PBIX file alongwith the link of the video which I created recently based on this topic as well as link of one of the thread for the reference purposes.

Hoping this meets your requirements.

Note: In order to calculate the results by different dimensions adjust the context accordingly as per the scenario.

Thanks and Warm Regards,
Harsh

Calculation of % Share - Harsh.pbix (21.0 KB)

2 Likes