Forum Discussion

sandee's avatar
sandee
Helper I
5 years ago
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 ...
  • AntrikshSharma's avatar
    AntrikshSharma
    5 years ago

    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

     

  • sandee's avatar
    sandee
    Helper I
    5 years ago

    Hi Greg,

     

    thanks for the reference,

    it seems nothing is working here, i am not getting the desired output. working on one formula from almost one week, really Fed up.

    • AntrikshSharma's avatar
      AntrikshSharma
      Community Champion
      5 years ago
      sandee does my solution work for you?
  • sandee's avatar
    sandee
    Helper I
    5 years ago

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

    • AntrikshSharma's avatar
      AntrikshSharma
      Community Champion
      5 years ago
      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.
      • sandee's avatar
        sandee
        Helper I
        5 years ago

        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.