Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This query gives me the nuber of students spending more tha 3 hours on heir home work.
How do I work out what the percentage is of those against the total student population?
homework_OT - this is the main dataset
homework_OT[StudentID] - all the students and their IDs are in [StudentID]
homework_OT[OT 3HRS PLUS] =1 - this is to filter out all those students that have a 1 in [OT 3HRS PLUS] to indicate that they spent more than 3 hours on their homework
What calculation will give me the % of [OT 3HRS PLUS] =1 from the total student population?
Solved! Go to Solution.
@acg , Try a measure like
CNT Homework > 3 HRS =
divide( CALCULATE (
DISTINCTCOUNT( homework_OT[StudentID]),
FILTER ( homework_OT, homework_OT[OT 3HRS PLUS] =1 )
), DISTINCTCOUNT( homework_OT[StudentID]))
or
CNT Homework > 3 HRS =
divide( Countx (FILTER (
values( homework_OT[StudentID]), calculate(sum(homework_OT[OT 3HRS PLUS])) >=1 ), [StudentID]), DISTINCTCOUNT( homework_OT[StudentID]))
@acg , Try a measure like
CNT Homework > 3 HRS =
divide( CALCULATE (
DISTINCTCOUNT( homework_OT[StudentID]),
FILTER ( homework_OT, homework_OT[OT 3HRS PLUS] =1 )
), DISTINCTCOUNT( homework_OT[StudentID]))
or
CNT Homework > 3 HRS =
divide( Countx (FILTER (
values( homework_OT[StudentID]), calculate(sum(homework_OT[OT 3HRS PLUS])) >=1 ), [StudentID]), DISTINCTCOUNT( homework_OT[StudentID]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |