classification problems

[Anonymous]

Hi friends, I need help here. I'm trying to show the top 50 records in wise range. when I have a connection in the columns it shows correctly, but when I drag to other table columns the sorting functionality is not working and is not showing the top 50 records instead of that I'm getting huge data and range is giving asc 1 and dsc 2. How I get unique records like 1 to 50 on a kind of paid amount base.

Rank_TOP50 DE la clase RANKX(all('Network License'[Network License Number]),CALCULATE([Paid Amount]),,DESC,Skip)

Note: Here all the columns come from different tables.

[amitchandak]

@Anonymous , in this first one it should work. Also, you can use the Top N filter on a group by field in the visual level filter.

https://www.oreilly.com/library/view/mastering-microsoft-power/9781788297233/378a5195-3e98-4cc1-bcd3-92904dfbfb4f.xhtml

If you add more groups to the table then ranking will not work. You need to add all those columns in all.

[Anonymous]

amitchandak, Thanks for your reply. Please help me if am adding other columns into the table it will give below issue how can i overcome this issue and display TOP 50 records only.

[amitchandak]

@Anonymous , Does it allow you to go to visual level filter for this column and choose the advance option TOP N, and choose measure and filter

[Anonymous · Accepted solution]

Hi Amit, since I already applied TOP N so it doesn't allow me to apply TOP 50 on the visual level, so instead I'm giving less than 50 in the measure, but now it's showing range is always 1.

[amitchandak]

@Anonymous , Rank on the measure is a bit confusing. If you create Rank on Column A(grouped column), It means rank on the column under any other group by. When I do not use any other text column/group, it displays correctly, But If use Column B in visual with A, where A has been used in Rank. Now It will try to Rank A inside B. Hence you will get that kind of the result.

So better is a visual level filter, Clean all visual filter and remove Rank and filter directly in Measure using Top N

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale