SUM with two-variable filter

[Syndicate_Admin]

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.

[Ritaf1983 · Accepted solution]

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 case 

Please 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/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

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

[Ritaf1983 · Accepted solution]

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 case 

Please 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/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Syndicate_Admin]

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:

[Ritaf1983 · Accepted solution]

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

[Syndicate_Admin · Accepted solution]

Fixed with the correct syntax.