dax

[Anonymous]

Hi

i am looking fox to show top5 problems

[ryan_mayu · Accepted solution]

@Anonymous 

you can try TOPN

https://docs.microsoft.com/en-us/dax/topn-function-dax

or

use topN filter

[v-yetao1-msft · Accepted solution]

Hi @Anonymous ,

The problem you asked is not very clear , I hope you can give more data .

I will probably give a plan based on your needs . If you have any questions, you can continue to ask .

You can use TOPN DAX to create a table and filter the top5 of the data you want .

Column = TOPN(5,'Table','Table'[Sales],DESC)

The effect is as shown:

Or you can use the TopN function in Filters . Add the data fields in By value to filter .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu · Accepted solution]

@Anonymous 

you can try TOPN

https://docs.microsoft.com/en-us/dax/topn-function-dax

or

use topN filter