Forum Discussion
Not working: Top N functionality (TOP N by "count" column if the count is repetitive)
Hi, Samruddhi_11 ;
As far as I know, topn is to display the first few, first if you set topn5, then count=11 is the largest sort, but count=11 name is more than 5, then topn5 only display count=11;
For example, if you have four rows count=11 and two rows count=10, then topn5 displays six rows, Anyway, it's counting repeating columns.
so we could create a mesure.
rank = RANKX(ALLSELECTED('Table'),CALCULATE( COUNT('Table'[name])),,DESC,Dense)Then could set less than or equal to .
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Samruddhi_11 , based on what I got. Create a dense rank and use that in the filter in visual level filter for <= 5
rankx(allselected(Table[Pin name]), [Count of pin measure],,desc, dense )
Hi amitchandak ,
Thank you for your valuable solution but getting one problem if I select top 3 then only those rows are coming having count 2 and 4 . after 4 it should display rows with 7 count but its not showing so its not working for top 3 , 4 and 5. please help me in this.
I attached 2 screenshots after applying top 3 in filter:
1. Ascending of count
2. Descending of count
Samruddhi_11 , can you share the measure. Also make sure in rank you have used measure, not just count(Table[Column]) , if you have used that then use calculate(count(Table[Column]))
Hi amitchandak ,
Below is a measure,
Measure2 =RANKX(ALLSELECTED(cloud_pricing_export[sku]), cloud_pricing_export[Count of sku],,DESC,Dense)where ,cloud_pricing_export = table namesku = pin namecount of sku = measureFormula:Count of sku =COUNT(cloud_pricing_export[sku])Samruddhi_11 can be resolved a lot quicker, if you can provide sample data and expected output.
