cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Re: Hide value

Hi @Floriankx,

 

sorry for late

 

I understand what u trying to teach me

 

but I told u before if data is duplicate then rankx gives same number for data.

 

Note:- make some value duplicates in data

 
Sub
 
Sub Category
 
Data
ACD94
ACD94
ACD69
ACD55
ACD53
AEF90
AEF87
AEF87
AEF71
AEF53
AGH99
AGH99
AGH78
AGH75
AGH62
BIJ96
BIJ95
BIJ77
BIJ69
BIJ61
BKL89
BKL87
BKL64
BKL63
BKL60
BMN81
BMN80
BMN77
BMN61
BMN56

 

Result I get :-

HIde value.JPG

See Max2 is not showing because of duplicate data (max1 - 99 & Max2 - 99).

 

hide value2.JPG

Similar case in Sub category.

 

formula.JPG

 

Any suggestion (how I achieve my original situation)

 

Regards,

NICK

Floriankx Established Member
Established Member

Re: Hide value

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.

Re: Hide value

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

 

 

Re: Hide value

Hi all,

 

help to out this guyz.

 

 

Regards,

NICK

 

Highlighted
Floriankx Established Member
Established Member

Re: Hide value

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:

image.png

 

For me it looks like it is supposed.

Re: Hide value

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