Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone,
Sample dataset
City | Population | Utilization% |
Bangalore | 20.00 | 44 |
Mangalore | 10.00 | 22 |
Mysore | 15.00 | 33 |
Total | 45.00 |
I am trying to create a measure for Utilization% and below is the formula :
Utilization% = SUM(total population for individual cities) / Total population * 100.
Eg : Utilization% = SUM(20) / 45 * 100 = 44 (Bangalore)
How to achieve this measure in Power BI?
Much appreciated for help.
Hello @Rajeshaxxonet
this should be a simple:
Utilization% =
DIVIDE (
SUM ( Cities[Population] ),
CALCULATE (
SUM ( Cities[Population] ),
ALL ( Cities[city] )
)
) * 100
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |