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...
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]))