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  Try using "True()". 

Checked Finance = CALCULATE(SUM(FACT_NEWBI_NewSalesDashboard[SOOrderValue]),FILTER(FACT_NEWBI_NewSalesDashboard,FACT_NEWBI_NewSalesDashboard[SOPostingDate] = BLANK() && FACT_NEWBI_NewSalesDashboard[InvoiceNumber] = BLANK() && FACT_NEWBI_NewSalesDashboard[InvoiceChecked] = True()))

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Here is some sample data.... not working 

CreatedOnSOOrderValueSOPostingDateInvoiceCheckedInvoiceNumber
20-Jan-22£326.04 True 
18-Jan-22£2,780.8 True 
19-Jan-22£1,346.85 True 
19-Jan-22£119.02 True 
20-Jan-22£570.23 True 
18-Jan-22£1,159.81 True 
  • 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.