Error data types Variant

[Anonymous]

Good, when I perform this measure, I get the following error.

My table is as follows:

[v-jingzhang · Accepted solution]

Agree that it is because the three return results of your IF function are not the same data type. You can use 

DIVIDE([Measure],2,0)&"" or CONVERT(DIVIDE([Measure],2,0),STRING) to convert the value to Text.

Reference: https://docs.microsoft.com/en-us/dax/convert-function-dax

[amitchandak]

@Anonymous , Two if return Text, the lat one return Number, so that will work. In the last else return add  & "" . So that it becomes text.