topic Re: Conditional select of unichar up and down arrows is not working in DAX Commands and Tips

Conditional select of unichar up and down arrows is not working

Anonymous — Wed, 22 May 2019 05:10:54 GMT

Hi all,

I have to display unichar up and down arrows based on a measure.

My DAX is as follws

percentagedifference = IF([YTD difference]>=0, UNICHAR(9650), UNICHAR(9660))

Why is my output wrong.?

parry2k — Wed, 22 May 2019 10:33:13 GMT

Anonymous are you adding perecentagedifference as column or measure? It has to be a measure.

Anonymous — Wed, 22 May 2019 22:11:31 GMT

Hi,

Its a measure.

YTD difference used in percentagedifference is a measure too which is built up on two other measures.

thisyearYTD sales and lastYearYTD sales.

Regards,

Anusha.

parry2k — Thu, 23 May 2019 00:05:06 GMT

Anonymous weird, can you share pbix file with sample data, remove any sensitive information before sharing.

Anonymous — Thu, 23 May 2019 21:23:10 GMT

Here is the link to the file. Kindly let me know if you are unable to access.

parry2k — Thu, 23 May 2019 21:36:01 GMT

Anonymous not able to download, it says to login with an account.

Anonymous — Sun, 26 May 2019 21:16:45 GMT

Are you able access this link.?

AkhilAshok — Mon, 27 May 2019 04:26:45 GMT

Looks like you have created percentagedifference as a Calculated Column instead of a Measure. Change it to a measure and it should work fine.

Anonymous — Mon, 27 May 2019 04:31:36 GMT

Thanks a lot mate. I cant believe i have made such an unnoticed silly mistake.

I was under an impression i made a measure.