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.

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

Hello I see,

 

but PowerPivot is simply amazing, I think there is an OnBoard Solution.

Check out RANKX RANKX(<table>, <expression>[, <value>[, <order>[, <ties>]]])

 

So you could add RANKX(Test_Rank;[Data];;Dense)

I think the description in the link is well done. So this should help.

Naveennegi119's avatar
Naveennegi119
Helper III
8 years ago

Hi Floriankx,

 

RANKX(Test_Rank;[Data];;Dense)

 

Not working in my case. please try to use once in your side.

 

Maybe some important thing u get

 

Regards,

NICK

 

 

  • Floriankx's avatar
    Floriankx
    Solution Sage
    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 all,

     

    help to out this guyz.

     

     

    Regards,

    NICK

     

  • Naveennegi119's avatar
    Naveennegi119
    Helper III
    8 years ago

    Hi Floriankx,

     

    I was gone to trip, so could not read your msg.

     

    Thanks for every help you did it in past few days.

     

    Regards,

    NICK