Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Tie Breaker Rankx

Hi,

 

I need an easy tiebreaker fix that will breakup my Rankx formula. I am using the RankX to tie many data sets together and pull them into cards. This formula works for Ranking them except when there is a tie.

 

RankX by Actuals =
RANKX(ALLSELECTED(Tech),[FR Hours],,DESC)
 
I tried this Hasonevalue formula and it doesnt pull the name into the cards. There has to be a simple fix for this. Thanks for your help!
 
RankingNew =
If(Hasonevalue( Tech[Tech]),
RANKX(ALL(Tech[Tech]),
[Ranks By Actuals, Tiebreakers],,
DESC,
Dense),
Blank()
)
 
With this Tiebreaker formula:
Rank Tiebreaker =

VAR Ranking2 =
IF(
HASONEVALUE(Tech[Tech]),
Rankx(
All(Tech[Tech]),
[Today's Goal],,
DESC,
Dense),
Blank())

VAR RankScale =
Divide(
Ranking2,
100)

Return
If(HASONEVALUE(Tech[Tech]),
.20-RankScale,
blank())
 
Need Help