Measure to show up and down arrows in a table

[RJ_KON]

Hi guys, i am new to power BI and struggling to write measure to show up and down arrows based on my calculated coulmn values.

Below is my table

I am trying to create a measue KEY =IF([Difference]>0, UNICHAR (9650).UNICHAR (128315))

But in my measure KEY the formulae not showing up my calculated coulumn DIFFERENCE.

Below is my calculated coulmn for DIFFERENCE.

So is there a way how i can write this down to bring my measure Keyt to show up and down arows.

Need help.

[v-yulgu-msft · Accepted solution]

Hi @RJ_KON ,

Your measure should be:

KEY =
IF (
    SELECTEDVALUE ( VARIANCE_19_20[Difference] ) > 0,
    UNICHAR ( 9650 ),
    UNICHAR ( 128315 )
)

Best regards,

Yuliana Gu

[RJ_KON]

Hi Yuliana Gu, that worked perfectly.

Thank you very much.

RJ_KON