Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.