![1700483426_medium.pngcharsetUTF-8](https://quantinsightsnetwork.com/wp-content/uploads/2023/11/1700483426_medium.png;charset=UTF-8-219x381.png;charset=utf-8)
Sorting or ranking fields should be one of the most common requirements in our daily work. However, when we need to compare with multiple columns, it will not be suitable to use the rank function. Therefore, I would like to introduce a function that can help us meet our needs more easily.
Usage scenarios:
Sample data:
Sort multiple columns with filter
Condition: Group, Quality ASC, Sales DESC and Group not equal to D
Formula:
formula=
COUNTROWS (
FILTER (
'Sample',
ISONORAFTER (
'Sample'[Group], SELECTEDVALUE ( 'Sample'[Group] ), ASC,
'Sample'[Quality], MAX ( 'Sample'[Quality] ), ASC,
'Sample'[Sales], SUM ( 'Sample'[Sales] ), DESC
)
)
)
Result:
Reference link:
Sorting by multiple columns – Microsoft Power BI Community
ISONORAFTER function (DAX) – DAX | Microsoft Learn
Author: Xiaoxin Sheng
Reviewer: Kerry Wang & Ula Huang
Be the first to comment