Forum Discussion
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:
For me it looks like it is supposed.
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 |
| A | CD | 94 |
| A | CD | 94 |
| A | CD | 69 |
| A | CD | 55 |
| A | CD | 53 |
| A | EF | 90 |
| A | EF | 87 |
| A | EF | 87 |
| A | EF | 71 |
| A | EF | 53 |
| A | GH | 99 |
| A | GH | 99 |
| A | GH | 78 |
| A | GH | 75 |
| A | GH | 62 |
| B | IJ | 96 |
| B | IJ | 95 |
| B | IJ | 77 |
| B | IJ | 69 |
| B | IJ | 61 |
| B | KL | 89 |
| B | KL | 87 |
| B | KL | 64 |
| B | KL | 63 |
| B | KL | 60 |
| B | MN | 81 |
| B | MN | 80 |
| B | MN | 77 |
| B | MN | 61 |
| B | MN | 56 |
Result I get :-
See Max2 is not showing because of duplicate data (max1 - 99 & Max2 - 99).
Similar case in Sub category.
Any suggestion (how I achieve my original situation)
Regards,
NICK
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.
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.
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
Hi all,
help to out this guyz.
Regards,
NICK
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