Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
What is the difference between these two ?
Thanks!
Regards!
Solved! Go to Solution.
@tutuk28
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
I @tutuk28 , 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.
I think if you put a visual filter that would be better.
Not sure what excately looking for.
Hi @amitchandak !!
I'm trying to understand the difference between the top N with the filter or using the dax measures.
@tutuk28
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |