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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

 

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper 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()))