Forum Discussion

Naveennegi119's avatar
Naveennegi119
Helper III
8 years ago
Solved

Hide value

Hi All,   It really very complicated to me to resovle.   when I select sub then it show fine top 3 value (situation 1)       But when i select both(sub and sub category), it show the valu...
Need Help
  • Floriankx's avatar
    Floriankx
    8 years ago

    Hello,

     

    I couldn't test 'Dense' last week so I did it today.

     

    My Measure is TopN:=CALCULATE(MAX(Test_Rank[Data]);FILTER(Test_Rank;RANKX(Test_Rank;[Data];;;Dense)=Top_3[MaxN]))

     

    This is my over all:

     

    For me it looks like it is supposed.

Naveennegi119's avatar
Naveennegi119
Helper III
8 years ago

Hi Floriankx

 

thanks for sharing idea,

 

but rankx give same number for duplicate data

 

Regards,

NICK

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

Hello can you make a screenshot?