topic Re: Need some clarifications with TOPN & how to add more criteria in DAX Commands and Tips

Need some clarifications with TOPN & how to add more criteria

JustinDoh1 — Mon, 15 Sep 2025 23:44:32 GMT

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.

lbendlin — Tue, 16 Sep 2025 01:05:16 GMT

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

Praful_Potphode — Tue, 16 Sep 2025 05:52:48 GMT

you can try below snippet.

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