Percentage of Total

[M_SBS_6]

Hi, 

I have the following table

ID.  Value 

1.    100

2.     300

3.     500

Total 900

What I want is the individual Value as a percentage of the total. 

ID.  Value %

1.    100 11%

2.     300 33%

3.     500 55%

Total 900

[jdbuchanan71 · Accepted solution]

Have a measure just to sum your value

Value Amount = SUM ( 'Table'[Value] )

Then a measure to calclualte the % of Total.

% of Total = DIVIDE ( [Value Amount], CALCULATE ( [Value Amount], ALLSELECTED ( 'Table'[ID] ) ) )