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

[kenneth25]

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))