Calculating Percentage for Individual dimension

[Rajeshaxxonet]

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.

[LivioLanzo]

Hello @Rajeshaxxonet

this should be a simple:

Utilization% =
DIVIDE (
    SUM ( Cities[Population] ),
    CALCULATE (
        SUM ( Cities[Population] ),
        ALL ( Cities[city] )
    )
) * 100