If function

[Anonymous]

Hi, 

I have created this measure

Arrow R12 Rank = if([Rolling 12 Difference Rank]>0,"↑",if([Rolling 12 Difference Rank]=0,"-","↓"))

The rolling 12 difference is -1 but when I am putting the formula in a card I am getting "-", as the formula is recognising the answer as 0.

Rolling 12 Difference Rank = [Rolling 12 PY Rank] - [Rolling 12 Rank]

Rolling 12 Rank = RANKX(ALL(Client[Clients]),VALUE(Financials[Premium]))

Rolling 12 PY Rank = RANKX(ALL(Client[Clients]),VALUE(Financials[ PY Premium]))

 Rolling 12 rank = 22

Rolling 12 PY rank = 21

Any ideas why?

[Greg_Deckler]

@Anonymous Try:

Arrow R12 Rank = 
  VAR __RollingDiff = [Rolling 12 Difference Rank]
  VAR __Result = 
    SWITCH(TRUE(),
     [Rolling 12 Difference Rank] > 0,"↑",
     [Rolling 12 Difference Rank] < 0,"↓",
     "-"
    )
RETURN
  __Result