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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.