Add a column that shows the percent contribution to the total of another column

[cm008507]

I have a table visual with a cost category column with the total costs for each category.  PowerBI then provides the overall total for all of the rows.   I would like to add a column that shows the percent contribution of the overall total from each cost category.    Would I use a calculated column or measure or other?   

[Ritaf1983 · Accepted solution]

Hi @cm008507 
you can use a measure with dax "all" function.

%fromAll = SUM('Table'[value])/CALCULATE(sum('Table'[value]),all('Table'[Category]))

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @cm008507 
you can use a measure with dax "all" function.

%fromAll = SUM('Table'[value])/CALCULATE(sum('Table'[value]),all('Table'[Category]))

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[cm008507 · Accepted solution]

That worked perfectly!  Thank-you Ritaf1983.

[Ritaf1983]

It was my pleasure to assist 🙂

[Syk]

From what you described, you could use a measure. You could also likely just reselct your cost column and select show value as a % of grand total.

[mungerja]

I was here with the same question.  Sometimes the easiest answer is right in front of your face.  Thank you!