Forum Discussion
HunterAlpert
5 years agoHelper I
Grouping data together
I have a dataset which includes the person, and their average score. I need to break those scores out into buckets of >90, >80, etc. with the count of people who averaged that score. However, I am ha...
- Anonymous5 years ago
Hi HunterAlpert ,
Based on your description, you can do some steps as follows.
- Create a calculated column to mark the range.
Score Range = SWITCH(
TRUE(),
[Average Scores]>=90&&[Average Scores]<100,"90-100%",
[Average Scores]>=80&&[Average Scores]<90,"80-89%",
[Average Scores]>=70&&[Average Scores]<800,"70-79%",
[Average Scores]>=60&&[Average Scores]<70,"60-69%",
"<69%")2. Create a measure to count filtered rows.
Number in column = COUNTROWS(FILTER(ALL('Table 3'),'Table 3'[Score Range]=SELECTEDVALUE('Table 3'[Score Range])))Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HunterAlpert
5 years agoHelper I
This is exactly what I needed! Thank you!
- Ashish_Mathur5 years agoSuper User
Hi,
Is it me that you replied to? If my reply helped, please mark it as Answer.