cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rajeshaxxonet Frequent Visitor
Frequent Visitor

Calculating Percentage for Individual dimension

Hi Everyone,

 

Sample dataset

 

CityPopulationUtilization%
Bangalore20.0044
Mangalore10.0022
Mysore15.0033
Total45.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 1
Super User
Super User

Re: Calculating Percentage for Individual dimension

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!