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. InvoiceNumber = blank

the below is returning back blank when i clearly know i have values in [SOOrderValue]

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

 

Need Help

7 Replies

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