Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Rajeshaxxonet
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
LivioLanzo
Solution Sage
Solution Sage

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!  

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.