Sorting columns in a calculated table with FILTER(), is it possible?

[ikelaiah]

Hi,

I have the following filtered calculated table.

Active Job Records Table = 
FILTER('job records data', 
        'job records data'[job_start_date] <= NOW() && 
        'job records data'[job_end_date] >= NOW() &&
        'job records data'[job_status] = "t"
)
  

Is it possible to sort calcualted table based on the following columns?

'job records data'[pay_level] descending
'job records data'[job_start_date] descending
'job records data'[job_start_date] descending

 
Thanks in advance.

-ikel

[amitchandak]

@ikelaiah , I a table visual, you can put all these columns and can do multiple column sort using shift and click

[ikelaiah]

That does the trick. But is it possible to do FILTER() and sort/order by at the same time?

[v-kelly-msft · Accepted solution]

Hi  @ikelaiah ,

Yes,you can use Rankx as a variable then use filter to get the rows you need:

https://docs.microsoft.com/en-us/dax/rankx-function-dax

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!