Forum Discussion
SUM with two-variable filter
Hello Community,
Can you help me explain the correct way to apply the two-variable filter to the sum of a column of data?
I created a variable called EAC 2024 according to the graph, Here I have applied a single filter (OPEN) and the two values match:
But when I apply two filters: OPEN and CLOSED, the EAC variables become zero.
Which I need to adjust in the DAX code.
Thank you
Julian P.
Hi Syndicate_Admin
This happens because the state can't be open and closed at the same time.
If you need to return the result of open+closed please use "||" instead of "&&" (or instead of and).
In other casePlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Syndicate_Admin
You have the wrong syntax...The end of the measure should be
...'projects[project state] = "open" || 'projects[project state] = "closed"If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Fixed with the correct syntax.
4 Replies
Hi Syndicate_Admin
This happens because the state can't be open and closed at the same time.
If you need to return the result of open+closed please use "||" instead of "&&" (or instead of and).
In other casePlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello
I agree with what you say in the condition that applies to the filter, however I can't manage to apply it correctly:
I also did this test without success:Hi Syndicate_Admin
You have the wrong syntax...The end of the measure should be
...'projects[project state] = "open" || 'projects[project state] = "closed"If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly