Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How can I fix this error in DAX code?

Experts, please help to fix the DAX code on the below error. I need to keep this Calculated Column in Matrix visual to include in the Rows group.

 

 

  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Customer total order is number type and NA is text

     

    to either change to text like examples

     

    [Customer total order] & ""

     

    or

     

    format([Customer total order], "###,###")

     

    or use blank()  in place of N/A

  • Anonymous's avatar
    Anonymous
    4 years ago

    Wow, It's been fixed with your second one. that's great suggestions and quick fix from you. That's the reason tagged you 🙂

3 Replies

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      Anonymous , Customer total order is number type and NA is text

       

      to either change to text like examples

       

      [Customer total order] & ""

       

      or

       

      format([Customer total order], "###,###")

       

      or use blank()  in place of N/A

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Wow, It's been fixed with your second one. that's great suggestions and quick fix from you. That's the reason tagged you 🙂