Forum Discussion
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...
hi ttotheb
could you use the numbers in your dataset and put them in a equation to get 58.1%?
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