Forum Discussion

vijayan_ja's avatar
vijayan_ja
Frequent Visitor
7 years ago
Solved

DAX measure for top 10 rank using Rankx function

Dear all,   i am looking for the output of top 10 values based on the category(Subject), The problem is i am working on the real time dataset, which dosen't allow to use any calculated column.   ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi vijayan_ja ,

     

    Please try this:

    Rank =
IF (
    [FlagLatest] = 1,
    RANKX (
        FILTER (
            ALLSELECTED ( RealTimeTest ),
            [FlagLatest] = 1
                && RealTimeTest[metric_name] = MAX ( RealTimeTest[metric_name] )
        ),
        [SumwithContext],
        ,
        DESC,
        DENSE
    )
)

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi vijayan_ja ,

 

Please try this:

Rank =
IF (
    [FlagLatest] = 1,
    RANKX (
        FILTER (
            ALLSELECTED ( RealTimeTest ),
            [FlagLatest] = 1
                && RealTimeTest[metric_name] = MAX ( RealTimeTest[metric_name] )
        ),
        [SumwithContext],
        ,
        DESC,
        DENSE
    )
)

Best regards,

Yuliana Gu