Forum Discussion

YYS89's avatar
YYS89
Copper Contributor
Aug 08, 2023

Power Pivot help needed - calculating share per segment

hi all, 

 

I'm working in a CPG company and want to set up a power pivot to calculate shares for me. However when I set up the calculation in the Power Pivot itself, you will see that the value share is all 100% per product or a % of the total value sales instead of the value share of country A or B.

 

What I'm looking for is the value share per product in Country A or B like the column in green (manually calculated). Can someone please help me how to do this and which DAX formula is best to use?

 

 

Thanks in advance! 

 

excel

1 Reply

Sort By
  • nimesht's avatar
    nimesht
    Iron Contributor
    Aug 12, 2023

    Hi YYS89 

     

    Right Click on the column to modify the value (currently "Sum of Value Share Year Ago") and choose "Show Values As" > "% of Parent Total" and choose Country field in the dialog box.

     

    Use Like if this post helped to solve your issue and Mark as Best Response if the request can be closed.

Resources