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 colum...
  • arvindsingh802's avatar
    1 year ago

    Make Sure you are creating a measure 

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