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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
slhangen
Helper II
Helper II

Percentage of population

I have 2 tables with a related field called School.

One table, ContactData, has columns with student name and school name.

The other table, School Size, has 2 columns: school name and school population.

 

I need to display the % of interventions for selected school.

For example:

In the School Size table, school A has a popualation of 500. 

In the ContactData table, there is 450 rows of contacts for school A.

 

How do I construct a measue that gives me the 450/500 or 90% I can use in a visual?

 

Thx community in advance!

 

4 REPLIES 4
debean
New Member

Hi, it sounds like you'd like to calculate the population share that is registered with a name out of the total population for that school.

 

Perhaps try if this works and is what you seek by selecting the School-field and the measure in for example a table visual.

 

PopulationShare = Divide(Distinctcount(ContactData[StudentName]) , SchoolSize[SchoolPopulation])

Not able to pull in Population. See attached picture for schema. Thx for your assistance. 

image.jpg

image.jpg

image.jpg

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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