Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
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.
User | Count |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |