Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sorting columns in a calculated table with FILTER(), is it possible?
06-08-2021
11:04 PM
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
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2021
01:42 AM

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!
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2021
11:32 PM

That does the trick. But is it possible to do FILTER() and sort/order by at the same time?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2021
01:42 AM

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!

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
07-08-2024 02:22 PM | |||
Anonymous
| 03-13-2024 03:01 PM | ||
05-29-2024 02:15 AM | |||
03-25-2024 04:57 PM | |||
08-14-2024 11:19 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |