Top N with Rankx for negative number

[pvtrinh89]

Dear Experts,

I am dealing with a trouble when RANKX function was not working for me because my measure conntaining negative figures, Could anyone suggest me a solution for this issue?

Best regards,
J.

[v-qiuyu-msft]

Hi pvtrinh89,

Please provide more information to elaborate the issue. You can share a sample .pbix for our analysis if possible.

By the way, you can take a look at links below:

RANKX Function (DAX)

Power BI Pro Tip: Show Top x results with RANKX() function

Best Regards,
Qiuyun Yu

[Sean]

RANKX works with negative numbers - what Measure have you written - you have to provide some details...