Forum Discussion
Calculate Share based on Slicers
Hello,
I have created a matrix where I have the sales amount for some suppliers or brands based on some slicers. The column MAT TY represents the sales value for this year, LY for last year.
I want to create a Share for each Supplier/ Brand which should be applicable depending on the slicer. So for ex. if I select a specific Category I want to see the Share the supplier has in that category. If I select no category I want to see the Share that the supplier has in the "Group"(second slicer). I tried to put the Value for Sales(MAT TY) and show it as a percent of total column, but the problem is that if I select a specific supplier from one matrix, it changes (becomes 100% because it is calculated based on column). How can I calculate this Share in a way it can be visible when i select the supplier?
I created a Share column, but the formula is not correct.
After that, I need to create a matrix with Value % Share change, the will contain the percent difference between this year's share and last year's share.
Thank you!
Check, if you create sub total like this. Does that help you
https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
3 Replies
- amitchandak
Super User
Check, if you create sub total like this. Does that help you
https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
- AnonymousNot applicable
- v-juanli-msft
Community Support
Hi Anonymous
Is this problem sloved?If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?If not, please feel free let me know.Best RegardsMaggie