Issue with RANKX function with "Don't Summarize" option

Hi, Anonymous 

Create a measure 'Rank' as below, then sort by column rank:

Rank =
RANKX (
    GROUPBY ( ALLSELECTED ( 'TestData' ), TestData[Category], TestData[Date] ),
    RANKX (
        ALLSELECTED ( TestData ),
        CALCULATE ( MAX ( TestData[Category] ) ),
        ,
        ASC,
        DENSE
    )
        + RANKX (
            GROUPBY ( ALLSELECTED ( 'TestData' ), TestData[Category], TestData[Date] ),
            CALCULATE ( MAX ( 'TestData'[Date] ) ),
            ,
            ASC,
            DENSE
        )
            / CALCULATE ( COUNTROWS ( 'TestData' ), ALLSELECTED () ),
    ,
    ASC,
    DENSE
)

Please check my sample file for more details. If it doesn't work, share a pbix file on cloud storage for further research.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.