topic DAX query - Sorted incorrectly in DAX Commands and Tips

DAX query - Sorted incorrectly

deepak_d03 — Thu, 05 Sep 2024 17:50:01 GMT

Data set (Table name - Table1) has the insurance complaints inforamtion. I am trying to get the top 10 days where maximum complaints have been filed.

Below is the DAX query result. Its not sorted correctly. Can anyone tell what going wrong?

TOPN(

10,

SUMMARIZECOLUMNS(

Table1[Received date],

"Complaint Count", COUNTROWS(Table1)

[Complaint Count],

DESC

)

Greg_Deckler tamerj1

Re: DAX query - Sorted incorrectly

AlexisOlson — Thu, 05 Sep 2024 18:01:39 GMT

TOPN does not guarantee any sort order for the results.

If you're writing a DAX query, you can add and ORDER BY clause at the end. For example,

EVALUATE TOPN ( 10, SUMMARIZECOLUMNS ( Table1[Received date], "Complaint Count", COUNTROWS ( Table1 ) ), [Complaint Count], DESC ) ORDER BY [Complaint Count] DESC

Re: DAX query - Sorted incorrectly

deepak_d03 — Thu, 05 Sep 2024 18:07:29 GMT

That worked. Thanks.

If I need to show this in report view, how do I do that?

Re: DAX query - Sorted incorrectly

AlexisOlson — Thu, 05 Sep 2024 18:48:49 GMT

Then you probably don't need any DAX. Just put the columns in a table visual, add a TopN filter in the filter pane, and sort by whichever one you want.