Forum Discussion
Solved
RANX Function
Hi All, this might be a very silly asking this question On RANK DAX, however i am new and learning POWER Bi. please if you could you help me. I have a table and i want to give "Ranking" on ...
sandee Is this how you want it? I have attached the file below my signature.
Measure = VAR Yes = CALCULATETABLE ( Sandee, Sandee[Debt Overdue] = "yes", ALL ( Sandee ) ) VAR No = CALCULATETABLE ( Sandee, Sandee[Debt Overdue] = "no", ALL ( Sandee ) ) VAR CurrentSelection = SELECTEDVALUE ( Sandee[Debt Overdue] ) VAR Ranking = IF ( CurrentSelection = "yes", RANKX ( Yes, [Total Due],, DESC ), RANKX ( No, [Total Due],, DESC ) ) VAR Result = IF ( ISINSCOPE ( Sandee[Debt Overdue] ), Ranking ) RETURN Result
Hi Antriksh,
Super Duper Shot ........ Great ......
the file u attached this is exactly i am after, i have not applied in my file as it seems stuck, but i will get back to you on this. Many Many thanks for this. God Bless You....
sandee Great, once you are able to replicate the same in your model and have no issues, then please mark my post as solved so that others can easily find the solution. Otherwise let me know if you still face any issue.
Hi Antriksh,
While accepting this as my solution i AM getting below error message again and again. i have checked everything is fine, but still same.
- sandee, no problem, I will do it on your behalf 😄