Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Measure Error when a column is blank empty data points

Hi Experts   i am trying to sum where the following columns are blank only and either True or false - my conditions are: 1. So PostingDate = blank 2. InvoiceChecked = true (text) 3. InvoiceNumbe...
Need Help
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    Anonymous  It is giving me this result

     

Tahreem24's avatar
Tahreem24
Super User
4 years ago

Anonymous  It is giving me this result

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

in a card visual

  • Tahreem24's avatar
    Tahreem24
    Super User
    4 years ago

    Anonymous  You need to check the data type of SOOrderValue column. It should be Numeric column. I am attaching the PBIX file for your reference please check the Power Query how I converted that column into numeric due to currency symbol.