Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
Hi @cm008507
you can use a measure with dax "all" function.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @cm008507
you can use a measure with dax "all" function.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
That worked perfectly! Thank-you Ritaf1983.
It was my pleasure to assist 🙂
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.
I was here with the same question. Sometimes the easiest answer is right in front of your face. Thank you!
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |