Forum Discussion

Cyriackpazhe's avatar
Cyriackpazhe
Icon for Helper III rankHelper III
1 year ago

RankX

Why am i getting the output like this
techies's avatar
techies
Icon for Super User rankSuper User
1 year ago

pls try this - 

Measure =
VAR totalamount = [Enrollment Amount]

VAR QuarterRank =
    IF (
        ISINSCOPE ( 'DATE'[quarter]),
       RANKX (
            ALLSELECTED ( 'DATE'[quarter] ),
            [Enrollment Amount],
            ,
            DESC,
            DENSE
        )
    )
VAR Result =
    IF (
        NOT ISBLANK ( totalamount ),
        QuarterRank
    )
RETURN
    Result