Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating Buckets based on Top N Numbers

Hi, I am trying to find out a solution for showing Top Numbers as in bucket format. Ex:- I have a column (Messages). I need to find out Top 5 messages , top 5 to 10 messages , top 10 to 15 messages.I...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago
    Ranking = 
Var YourRank = RANKX(
    FILTER(Tble,
            Tble[Class]=EARLIER(Tble[Class])
    )
    ,Tble[Sl.No],,ASC
)
Return
SWITCH(
        TRUE(),
        YourRank<=5,"Top 5",
        YourRank>5 && YourRank<=10,"Top 5-10",
        YourRank>10 && YourRank<=15,"Top 10-15",
        "More than 15"
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create a new calcuated column in the table with below DAX.

Use this column as filter along with the filter for class.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Ranking = 
Var YourRank = RANKX(
    FILTER(Tble,
            Tble[Class]=EARLIER(Tble[Class])
    )
    ,Tble[Sl.No],,ASC
)
Return
SWITCH(
        TRUE(),
        YourRank<=5,"Top 5",
        YourRank>5 && YourRank<=10,"Top 5-10",
        YourRank>10 && YourRank<=15,"Top 10-15",
        "More than 15"
)