Forum Discussion
DAX HELP: TOPN VALUE IGNORING REPETITIONS
Hi all, I' ve got a table A with a column Sales containing int numbers: I'd like to create a new table B from table A populated with all the rows containing the 4 greatest numbers (maintaining re...
Create a rank and filter based on that
rank = rankx(all(TableA),TableA[Sales],,desc,dense)
And filter on rank.
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