Forum Discussion
Creating Buckets based on Top N Numbers
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" )
Here the top 5 need to be decided by which cloumn, is there any seperate fact(like sales) for the same or top from the first column serial number?
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" )