This content has been marked as final.
Show 2 replies
-
1. Re: Row-number after double sort/rank on measure
Michel Caissie Oct 13, 2016 7:28 AM (in response to Johan De Groot)Johan,
You can go with
RANK_UNIQUE( (100 * SUM( [Rating] )) + SUM( Value2 ))
Depending on how big Value2 can get you can change the multiplier of 100 for something bigger (in case SUM(Value2) would be higher than 100*SUM(Rating).
See in the attached...
Michel
-
sortRank ed mc.twbx 37.2 KB
-
-
2. Re: Row-number after double sort/rank on measure
Johan De Groot Oct 13, 2016 11:27 AM (in response to Michel Caissie)Thanks - that should do the trick!
With a total of value2 as the multiplier of the rating I should be safe using the formula.
Kind regards,
Johan