Forum Discussion

MaleneL's avatar
MaleneL
Resolver I
3 years ago
Solved

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

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

 

Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

     

    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

3 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    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's avatar
      MaleneL
      Resolver I
      3 years ago

      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's avatar
        BA_Pete
        Super User
        3 years ago

         

        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