Forum Discussion
Formula
how to calculate and get percentages in a column?
For any calculations you need to use calculated columns or measure
how to calculate measure? then for example, Sales 2022 value: cow is 544,385, and how to measure i can get percentage 43,06?
You got a column sales 2022 with value 544,385
Then you have a create an other calculated column for to get 43.06%
Formula for the column is :-
#column =
VAR _total = SUM([Sales 2022])
VAR _val = [Sales 2022]
RETURN
ROUND((_val / _total)*100,2)
then later you can use the #column For other calculationsYou can also use the same DAX in order to create a measure
bad;/
i get error: The SUM function only accepts a column reference as the argument number 1.