DAX expression error

[Anonymous]

Can somebody please help with below mentioned error?

[mader]

Hi. 

Verify if all of the columns you are comparing to "" are with data type Text. 

If you do not wish to change data type then the logic of comparing to blank should be changed. 

Consider using ISBLANK(<value>) 

[Anonymous]

Hi @Anonymous,

That would be your comparisons with "". For what I can see (can't know your fields types) but you have to substitute "" by >0 or blank() when you compare numeric fields and leave the "" for the text.

Let me know if it worked and if so mark as solution.

BR,

DR

[Anonymous]

This is still now working. Data type of ownsalestxid is text.

[Anonymous]

and I am creating a measure here.

[Anonymous]

What should the card visual show and do you have some sample data?

[Anonymous]

The card visual should show the no of documents where ownsalestaxid is blank.

[Anonymous]

In that case you could just use;

Measure = COUNTBLANK('BOT Output'[ownsalestaxid])

Or am i thinking too simple here? This works in my test file.

[Anonymous]

Probably would actually.

BR,

DR

[mader]

Hi. 
What values are actually calculated on those bad cases ?

 

[Anonymous · Accepted solution]

I can't see the data and don't know your data but try without the filter like:

CALCULATE(COUNT([DocumentID]),[ownsalestaxid]="")

Let me know the outcome.

BR,

DR

[Anonymous]

This doesn't work without selecting table name.

Mandatory fields missing = CALCULATE(COUNT('BOT Output'[Document ID]); 'BOT Output'[ownsalestaxid] = "" )

column [ownsalestaxid] is of type text.

[Anonymous]

One of the columns used is a number format, and others are text. As stated in the error you can use the value or format function to make it to text in this expression.