Forum Discussion
Top N filter help
Hello! I am trying to put together a Top 5 filter that should filter me a series of tasks, depending on its date of completion showing me only the 5 oldest.
I tried to do it directly using the Top N filter from the filters tab of the visual but I do not get the result I am looking for, I think because there are values that are repeated (which makes it show me much more than 5 values).
I have also tried to solve it by means of measures, for example with RANKX, but I did not reach the desired result either, what would be the best way to do it? What I need is to show if or if only 5 results, those of older date.
Thank you!
1 Reply
Syndicate_Admin , Make sure you are using values
example
calculate([Net Sales PY], TOPN(5, allselected('Address'[Country ISO]), [Net Sales PY],desc), values('Address'[Country ISO]))
