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

vijayan_ja's avatar
vijayan_ja
Frequent Visitor
7 years ago

As i mentioned, addind index column is not possible, due to the real time dataset. 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

interesting, well i guess you have to somehow find a unique record, seems like that is the requirement to solve your problem. I'm surprise that random didn't worked.