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?

  • 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

     

     

    • Floriankx's avatar
      Floriankx
      Solution Sage
      8 years ago

      Hello,

       

      Your MaxN is wrong. I ignored your calculated column and tried to build an independent measure only needing the columns category, sub category and Data.

      MaxN should relate to an independent table, which helps you to create Max1, Max2, Max3.

      If you want to display Situation 1 only if now Sub Category is selected, maybe this helps:

      Situation 1: IF(NOT(HASONEVALUE([Sub Category])),[TopN],BLANK())

      Situation 2: IF((HASONEVALUE([Sub Category])),[TopN],BLANK())

       

      Maybe this helps.

      • Naveennegi119's avatar
        Naveennegi119
        Helper III
        8 years ago

        Hi Floriankx,

         

        I'm confuse with MaxN

         

        How I get Max1, Max2 & Max3

         

        can u please sent a screenshot

         

        Regards,

        NICK