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 why don't you rank all your data with a measure and then let the slicer do the rest?

 

 

TopN:=CALCULATE(MAX(Test_Rank[Data]);FILTER(Test_Rank;RANKX(Test_Rank;[Data])=[MaxN]))

 

MaxN:=Max(Top_3[ID] which is a simple table containing heading and the values from 1 to 3.

 

  • 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?

      • Naveennegi119's avatar
        Naveennegi119
        Helper III
        8 years ago

         

         

        Hi Floriankx,

         

        your formula gives me max value of A & B,

        not give 2nd max and 3rd max.

         

        let me clear once again what i need

        Condition - 1

        if I select sub slicer then I get top 3 value of data. I'm using index method for that and i get top 3 value of sub, So first situation is done

         

        But

        Condition - 2

        when I select Both(Sub and Sub category) then I get top 3 value of data using the same method of index, that's fine too (as you see my previous attach images)

         

        Now problem is when i go with condition - 2  condition - 1 also appearing

        that what i what to hide

        Using condition-1 condition-2 hide

        Using condition-2 conditon-1 hide

         

        Hope u understand what i'm saying

         

        Regards,

        NICK