Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
Solved! Go to Solution.
@Anonymous It is giving me this result
@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"))
Hi Tahreem24, i did try that but getting the following error
@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()))
Here is some sample data.... not working
CreatedOn | SOOrderValue | SOPostingDate | InvoiceChecked | InvoiceNumber |
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 |
@Anonymous It is giving me this result
in a card visual
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |