If condition on percentage values giving wrong output

[Anonymous]

Hello All,

I am just trying to check whethe a column value having blank of zeros by below measure and show the message as data not available if any blank or zeros are there.

Sample table

But when i have written condition like the below measure it given me values in all decimals.

AttriCheck = IF(Attrition[Attri%]=BLANK() || Attrition[Attri%]<=0,"Data Not Available",Attrition[Attri%])

Output

 

Here the values are all in decimals and which are wrong also(Jan-2017 value).

Can anyone suggest me why is this happening in percentage values as it is perfectly works in all other types like decimals and whole number.

Thanks,

Mohan V

[Anonymous · Accepted solution]

Since the result of your measure always needs to be the same type (string in your case, since you have the error message), I would just use FORMAT to fixup your decimals.

Something like:

AttriCheck = IF(Attrition[Attri%]=BLANK() || Attrition[Attri%]<=0,"Data Not Available", FORMAT(Attrition[Attri%], "0.00%"))

[Anonymous]

Wow @Anonymous that was quick and perfect...

Kudos..