Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

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 h...
Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

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's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    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's avatar
      Ritaf1983
      Super User
      2 years ago

      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's avatar
        Syndicate_Admin
        Administrator
        2 years ago

        Fixed with the correct syntax.