Forum Discussion

AVAughan's avatar
AVAughan
New Member
1 year ago
Solved

Percentage Calculation

Hi there,

 

Sorry for a very basic query but I havent been able to find a solution online.

I have two columns in my table (Booked and Total) and want to find the utilisation for booking. The columns are various medical specialities. Howver when I try this formula -  

 

Utilisation = Utilisation[Booked]/(Utilisation[Total]) or Utilisation = SUM(Utilisation[Booked])/SUM((Utilisation[Total]))
 
The percentages are never calculated correctly. Is there anyone who can please help me
 
Thank you
Need Help
  • arvindsingh802's avatar
    arvindsingh802
    1 year ago

    Make Sure you are creating a measure 

    Percentage = SUM('Table'[Booked])/SUM('Table'[Total])
    And format it as %

     

3 Replies

  • arvindsingh802's avatar
    arvindsingh802
    Community Champion
    1 year ago

    Make Sure you are creating a measure 

    Percentage = SUM('Table'[Booked])/SUM('Table'[Total])
    And format it as %

     

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      1 year ago

      Hi AVAughan ,

      As suggested by arvindsingh802 , I wanted to check if your issue has been resolved.

      If their response addressed your query, kindly mark it as "Accept Answer" and click "Yes" if you found it helpful.

      Should you have any further questions, feel free to reach out.

      Thank you for being a valued member of the Microsoft Fabric Community Forum!

    • AVAughan's avatar
      AVAughan
      New Member
      1 year ago

      Thank you very much! Thats exactly where I was going wrong.