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,

 

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