Forum Discussion

HunterAlpert's avatar
HunterAlpert
Helper I
5 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi HunterAlpert ,

     

    Based on your description, you can do some steps as follows.

    1. 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.