Need some clarifications with TOPN & how to add more criteria

[JustinDoh1]

I have bottom DAX that illustrates TOPN:

My understanding with TOPN is that it returns the top row.

So, for this case, because we have same value for "MaxTotalWHSS", it would return 5 rows, instead of 1 row, correct?

How do I add more criteria so that it would be something like:

tblSurvey[MaxTotalWHSS] ASC and tblSurvey[ProcessingDate] ASC ? 

Thanks.

[Praful_Potphode · Accepted solution]

Hi @JustinDoh1 ,

you can try below snippet.

Table 2 = TOPN(1,
FILTER(
    ALL('Table'),
    'Table'[StartCutOff]>=0
),
'Table'[MaxTotalWHSS],ASC,'Table'[ProcessingDate],ASC)

[lbendlin]

You can specify multiple sort criteria for TOPN. TOPN function (DAX) - DAX | Microsoft Learn