Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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 ?
What is the difference between these two ?

Thanks!

Regards!

Anonymous
6 years ago
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

5 Replies

amitchandak
Super User
6 years ago
Anonymous

I think if you put a visual filter that would be better.

Not sure what excately looking for.
- Anonymous
  Not applicable
  6 years ago
  Hi amitchandak !!
  I'm trying to understand the difference between the top N with the filter or using the dax measures.
  - Anonymous
    Not applicable
    6 years ago
    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
6 years ago
I 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.
- Anonymous
  Not applicable
  6 years ago
  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.