Forum Discussion
Apply filter on measure
Sure, it goes something like this.
- Generates the list of unique Student / Course
- Filters that list to show only the lines where the student had at least one score > 5.5
- Generates a filtered list of the course table filtered to show just the Student / Course matches from step 2. We count this in one step but because we need the list from step 2 as a list we have to count the list from step 2 later.
- Then we divide the count of courses from step 3 by the count of _students (the list from step 2).
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
Step 2 is what gets you the list of the 3 students that passed course A.
When you say there are studends with scores < 5.5 do you mean in step 3? That is because you want to count all the tries for the students that passed. One of the tries for student 101 in course A is a 3.7 but you want to count it since his 2nd try he passed with a 7
Super UserAnonymous
I don't know of a way to do it without the VARs or other measure feeding into this one.
jdbuchanan71 Can you maybe explain it in detail then? 🙂
- jdbuchanan71
Sure, it goes something like this.
- Generates the list of unique Student / Course
- Filters that list to show only the lines where the student had at least one score > 5.5
- Generates a filtered list of the course table filtered to show just the Student / Course matches from step 2. We count this in one step but because we need the list from step 2 as a list we have to count the list from step 2 later.
- Then we divide the count of courses from step 3 by the count of _students (the list from step 2).
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
jdbuchanan71 I don't know exactly why step 2 is neccesary? Can you don't use this in the divide? Also in here why are there still students with a result lower than 5,5?
- jdbuchanan71
Step 2 is what gets you the list of the 3 students that passed course A.
When you say there are studends with scores < 5.5 do you mean in step 3? That is because you want to count all the tries for the students that passed. One of the tries for student 101 in course A is a 3.7 but you want to count it since his 2nd try he passed with a 7