variant data-type error

[afrutos]

Hi everyone,
I need some help here.
I have created a card where I need to get the gross value.
I am trying to create a formula so that, if the gross value is blank, it will put "Nothing pending", but it will calculate the sum of the gross value.
However, it is giving me an error that I can't solve.

These are my formulas:

Sin liquidar = SUM(Consulta2[BrutoMenosBonificacion])

Bruto NOBLANK = IF(ISBLANK([Sin liquidar]), "Nada pdte.", [Sin liquidar])

And this is the error I am getting: "Expressions that produce Variant data types cannot be used to define calculated columns."

[amitchandak · Accepted solution]

@afrutos , Power bi can have two data types for a measure , here text and number

what you can do is

Bruto NOBLANK = IF(ISBLANK([Sin liquidar]), "Nada pdte.", [Sin liquidar]& "" )

or

Bruto NOBLANK = IF(ISBLANK([Sin liquidar]), "Nada pdte.", format([Sin liquidar], "###,###.00") )

[afrutos]

Thank you is totally working for me now, could you please explain it to me why you do that?