Using TOPN DAX query

[subhendude]

I have a very basic table with a column latency. The latency stores the time it takes to execute in milliseconds.

I would like to see the top 20 records w.r.t the latency column in ascending order. Can anyone help me with the DAX query? I used the following one but the ordering is incorrect.

EVALUATE
TOPN (
    20,
    FILTER (
        Fact_APIData_Weekly,
        Fact_APIData_Weekly[ExecutionDate]
            = DATE ( 2022, 4, 23 )
    ),
    Fact_APIData_Weekly[Latency], TRUE
)

[Anonymous]

Hi @subhendude ,

As far as I know, there is no reliable way. You could click the filter drop down arrow on the column and select Sort.

Best Regards,

Jay

[subhendude]

@amitchandak 

The data is not getting sorted. The backend data is stored in Azure Data Explorer and I've used Power Query to prepare the data model. There is a date dimension table and fact table with latency numbers. I joined both the tables with the date column(one to many relationship)

Then I connect the PBI model with DAX studio and used the above DAX query. Unfortunately it gave me 20 records but not sorted by latency number.

[amitchandak · Accepted solution]

@subhendude , Try like, what is the issue you are getting

TOPN (
20,
FILTER (
Fact_APIData_Weekly,
Fact_APIData_Weekly[ExecutionDate]
= DATE ( 2022, 4, 23 )
),
Fact_APIData_Weekly[Latency], desc
)