cancel
Showing results for
Did you mean:  Resolver I

## Percentage of all Students spending more than 3 hours on their homework needed

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?

CNT Homework  > 3 HRS =
CALCULATE (
DISTINCTCOUNT( homework_OT[StudentID]),
FILTER ( homework_OT, homework_OT[OT 3HRS PLUS] =1 )
)
1 ACCEPTED SOLUTION  Super User

@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]))

Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines  Super User

@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]))

Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines Announcements #### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023. #### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers! #### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture. Top Solution Authors
Top Kudoed Authors
Users online (2,433)