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  You need to add "" while using True as a text.

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

    Hi Tahreem24, i did try that but getting the following error 

     

    • 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