Forum Discussion
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...
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" )
From the above table, I need Top0to5 messages of class A.
Table should show me the messages recordes as per my selection on drop downs.
If I select Top "0t05" in 1st drop down and select "a" in class dropdown. table should give me top5 of class a records.if i select "6to10" in 1st drop down and select a or "b" in class dropdown. table should give me top 6to10 of class a or b records as per drop down selection.
what column should we consider to create buckets drop down as (0to5,6to10,11to15 & 16to20).
Create a new calcuated column in the table with below DAX.
Use this column as filter along with the filter for class.
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" )