Forum Discussion
TOP N filter or DAX measure?
Hello, everybody! I have the following question, what is the best performance level for a TOP N? Do you prefer to use filters at display level or create a measure in DAX that performs TOP n ? W...
Anonymous
Usually you use the filter TopN in report visuals.The TOPN dax is a table expression used to create a table returns the top N rows of the specified table.Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
pceglie
Resolver I
Resolver II Anonymous , it depends 🙂
If you are looking for a simple topn filter you can set it on the visual, but if you're looking for something more advanced take a look here:
https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
Hope it will help you.
P.
Hi pceglie
What is the difference between doing it the way of filters or with a dax measure?
That's what I'm trying to understand.