would you know why this rank below not working in Power Bi

[Anonymous]

Rank(avg([Current Avg Balance]), 'Desc') - It works in Tableau not sure why not working in Power Bi

[audreygerred]

What result are you getting in Power BI and what is your expected result and what is the DAX formula you have in Power BI?

[Anonymous]

I just like to know how to rank within BI, the logic i used before in Tableau not working, what is best way to rank in BI

[audreygerred · Accepted solution]

You would use the RANK or RANKX functions, depending on what you needed: RANK function (DAX) - DAX | Microsoft Learn RANKX function (DAX) - DAX | Microsoft Learn