Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I have gone several posts before posting this Question in Community and didnt find a proper solution related to Top 5 and breaking ties .
So I wanted to resinstate discussion on this and check if there is solution for the issue.
I have date like below :
Product IncCount
ABC 590
BCD 45
BEF 10
JSH 2
JKS 1
SJS 1
When I apply Top 5 in visual filters ,I still see 6 rows as an output because of ties between JKS and SJS products.
Could some one please help me to fix this issue ?
I also tried creating a DAX code using Rank ,but failed .
Solved! Go to Solution.
Hi @Anonymous ,
You can refer to this post: How to Rank a list based on 2 values? double rankX?
And you can create your measures like so:
Primary Measure = MAX('Closed & Open INC'[IncCount])
Second Measure = MAX('Closed & Open INC'[Product])
Measure = RANKX ( ALL ( 'Closed & Open INC' ), RANKX ( ALL ( 'Closed & Open INC' ), [Primary Measure],, ASC ) + DIVIDE ( RANKX ( ALL ( 'Closed & Open INC' ), [Second Measure],, DESC ), ( COUNTROWS ( ALL ( 'Closed & Open INC' ) ) + 1 ) ) )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am trying to use this but I am not understanding where your column name 'column' is coming from??
Nothing is stated here about 'column'
Hi @Anonymous ,
You can refer to this post: How to Rank a list based on 2 values? double rankX?
And you can create your measures like so:
Primary Measure = MAX('Closed & Open INC'[IncCount])
Second Measure = MAX('Closed & Open INC'[Product])
Measure = RANKX ( ALL ( 'Closed & Open INC' ), RANKX ( ALL ( 'Closed & Open INC' ), [Primary Measure],, ASC ) + DIVIDE ( RANKX ( ALL ( 'Closed & Open INC' ), [Second Measure],, DESC ), ( COUNTROWS ( ALL ( 'Closed & Open INC' ) ) + 1 ) ) )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |