DAX query - Sorted incorrectly

[deepak_d03]

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 

[AlexisOlson · Accepted solution]

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

[deepak_d03]

That worked. Thanks. 

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

[AlexisOlson]

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.