Forum Discussion
DAX expression error
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
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
This is still now working. Data type of ownsalestxid is text.
and I am creating a measure here.
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
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.
What should the card visual show and do you have some sample data?
The card visual should show the no of documents where ownsalestaxid is blank.