Forum Discussion
Column Calculations
Hello, I have a field "% of Cost" that is a calculated column dividing the Total Cost by the Cost. It is added to a table like this...
I am trying to figure out how instead of the total at the top summing the percentages it could show the percentage of the Total Cost/Cost totals. So I wrote in red what I would like it to show (980,857/9,079,297).
I hope that made sense!
Thank you!
Hi ACraig08,
You need to modify the calculated field so that it calculates the ratio at the aggregate level, not summing the row-level percentages.
Instead of using a calculated column, you should use a DAX measure% of Cost = DIVIDE(SUM('Table'[Total Cost]), SUM('Table'[Cost]))Please let me know if you have any questions.
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
2 Replies
Hi ACraig08,
You need to modify the calculated field so that it calculates the ratio at the aggregate level, not summing the row-level percentages.
Instead of using a calculated column, you should use a DAX measure% of Cost = DIVIDE(SUM('Table'[Total Cost]), SUM('Table'[Cost]))Please let me know if you have any questions.
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
