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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.