Forum Discussion

Anonymous's avatar
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 ? W...
Need Help
  • Anonymous's avatar
    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous 

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

 

Not sure what excately looking for.

 

  • Anonymous's avatar
    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's avatar
      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