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)

     

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
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)