Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

kenneth25

The RANKX function error : When I apply filter conditions, the rankings become disordered.

Submitted by on ‎06-12-2025 01:47 AM
Initially, I thought the formula for the measure might be incorrect. However, when I randomly selected a table and refreshed it, the rankings returned to normal.

 

But when applying filter conditions again, the rankings become disordered (e.g., 2, 2, 3, 4, 5, 5). Strangely, randomly refreshing the data source fixes the issue again.
 
This is the formula：
                    IF(HASONEVALUE('TableA'[column1]),
                    RANKX(
                    ALLSELECTED('TableA'[column1],'TableA'[column2]),
                    Measure1,,
                    DESC,
                    Skip))
Status: New
See more ideas labeled with:
Comment
Idea Statuses