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)

     

     

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

Percentage%=DIVIDE([# Classes Canged],[# ALL classes],0)

  • Meme123's avatar
    Meme123
    New Member
    3 years ago

    Sorry, I should have noted that '#Classes changed' and '#All classes' are from two different tables.