Forum Discussion
Calculating Percentage for Individual dimension
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.
1 Reply
- LivioLanzo
Solution Sage
Hello Rajeshaxxonet
this should be a simple:
Utilization% =
DIVIDE (
SUM ( Cities[Population] ),
CALCULATE (
SUM ( Cities[Population] ),
ALL ( Cities[city] )
)
) * 100
