Trying to get market share to total 100% per column

[dgilm33]

Hello, I am currently working on something to try and show market share for two different categories. I'm having trouble though getting each column to show the percent of that category.  I have looked and tried several different formulas posted online, however I haven't had any luck with them. I also do not want to do "Show as % of grand total" as I am trying to show a variance as well and the percent of grand total does not show the variance correctly. I have attacehd snippets of the sample data with the columns, measures, and steps I have taken to try and  accomplish this. In the sample data, my goal would be to show 100% for shooting earnings, 100% for dunking earnings, and the correct variance.

[Ashish_Mathur · Accepted solution]

Hi,

Delete all your calculated column formulas.  To your matrix visual, drag Player from the Attributes Table and Skills from the Players Table.  Write these measures:

Earned = sum(Data[Earnings])

Total earned = calculate([Earned],all(Attributes[Player]))

Earnings (%) = divide([Earned],[Total earned])

Hope this helps.