Power BI DAX Function 'SWITCH' does not support comparing values of type True/False

[MaleneL]

I need to convert this to numbers, but getting the message:

"The 'SWITCH' function does not support comparison of values of type True/False with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values." 

Please help

[BA_Pete]

Hi @MaleneL ,

I think the issue is here:

These conditions would need to be written like this:

_calculation >= 0.0005 && _calculation < 0.001, 0.005,
_calculation >= 0.001 && _calculation < 0.002, 0.001,
... etc

Pete

[MaleneL]

no that's not it :O)

Still same issue:

"The 'SWITCH' function does not support comparison of values of type True/False with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values." 

[BA_Pete · Accepted solution]

Why are you using a comma separator in one part of your calculation, but a decimal separator in another?

If your native format is to display '0.001' as '0,001', then the DAX argument separators should be ' ; ' (semi colon) .

Option 1 = native decimal is comma:

_calculation >= 0,0005 && _calculation < 0,001; 0,005;

 Option 2 = native decimal is decimal:

_calculation >= 0.0005 && _calculation < 0.001, 0.005,

Pete