Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX expression error

Can somebody please help with below mentioned error?  
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

and I am creating a measure here.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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.