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

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        and I am creating a measure here.

  • mader's avatar
    mader
    Frequent Visitor
    6 years ago

    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>)