TOP N filter or DAX measure?

[tutuk28]

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!

[pceglie]

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.

[tutuk28]

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.

[amitchandak]

@tutuk28 

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

Not sure what excately looking for.

[tutuk28]

Hi @amitchandak  !!

I'm trying to understand the difference between the top N with the filter or using the dax measures.

[V-pazhen-msft · Accepted 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