Forum Discussion

ttotheb's avatar
ttotheb
New Member
3 years ago

Calculating ratios using measures

Hello everyone, I am new to PowerBI, and I have this calculation of ratio that I want to make in a measure, that has been bothering for quite some time now. I have searched for any possible soluti...
Need Help
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi ttotheb 

can you describe how to get 58.1%?

ttotheb's avatar
ttotheb
New Member
3 years ago

Hi FreemanZ 
Thank you very much for the reply.
So it would be the productivity ratio weighed by available resources for the plants.
Productivity ratio combined LA & NY 01/01/2023 =
(Available resources NY / Total available resources NY+LA * Productivity ratio NY) +
(Available resources LA / Total available resources NY+LA * Productivity ratio LA)

I really hope I make sense 🙂 
Thank you


  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi ttotheb 

    could you use the numbers in your dataset and put them in a equation to get 58.1%?

    • ttotheb's avatar
      ttotheb
      New Member
      3 years ago

      Hello,
      These would be the numbers.
      0,68/1,43*5/(0,68*12)+0,74/1,43*7/(0,74*17)
      Sorry, they don't add up to 58,1% when only using two decimal places. I didn't think about that.

      The point is, that I when I try to create a measure to calculate the productivity ratios, it adds up the capacities. Do you know if there is a way to keep those constant in a measure?

      Thank you