How can I fix this error in DAX code?

[Anonymous]

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 · Accepted solution]

@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]

@amitchandak @SpartaBI pls help

[amitchandak · Accepted solution]

@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 · Accepted solution]

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