Forum Discussion

ACraig08's avatar
ACraig08
Helper III
1 year ago
Solved

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...
Need Help
Tips and Tricks
  • ajaybabuinturi's avatar
    ajaybabuinturi
    1 year ago

    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.

ajaybabuinturi's avatar
ajaybabuinturi
Super User
1 year ago

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.