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 value sub and sub category. see below:-

 

 

 

 

Concatenate = CONCATENATE(Test[Sub],Test[Sub Category])

 

data for use(it showing error massage cannot exceed 20,000 charactars) that's why image attached

 

NICK
Regards, 

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.

15 Replies

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