Forum Discussion

Meme123's avatar
Meme123
New Member
3 years ago
Solved

Adding in a calculated column - percentage

Hello,  I'm fairly new to PowerBi and struggling with adding in calculated columns. I need to add a column (in the value field in this matrix table) that claculates the percentage of '#classes cha...
  • Samarth_18's avatar
    Samarth_18
    3 years ago

    Hi Meme123 ,

     

    You could create a measure as below and format it as percentage:-

    Percentage_classes = DIVIDE(sum('table1'[# Classes Changed]),Sum('table2'[# ALL classes]),0)

     

     

TomasAndersson's avatar
TomasAndersson
Icon for Solution Sage rankSolution Sage
3 years ago

Another easy way, if you don't need it to be a calculated column and are ok with a measure (that can be shown as a column in a matrix) could just be to calculate the sum for each and then divide them:

Percentage :=
DIVIDE(
    SUM([# Classes Changed]),
    SUM([# All Classes])
)

It might depend on how your data is structured, but a possiblity.