SUMX working correctly for one label, but not the other

[carly16]

Hi all,

I am trying to SUM values based on distinct criteria in three other columns. The data looks something like this:

I need to sum the Points column based on distinct Titles, where Platform = B, and Label = blocker. I have come up with the DAX below:

It works correctly for system "A" and returns 7, but if I change the system to "B" it no longer works. It seems to only execute the CALCULATE piece and returns 2, when it should be 4. Why is it no longer working by simply changing the system to the other one? Is there a way to write this better? Thanks in advance!

[Dangar332 · Accepted solution]

Hi, @carly16 

Try below measure 

measure =
SUMX (
    FILTER (
        SUMMARIZE ( 'table', 'table'[Points], 'table'[system], 'table'[label] ),
        'table'[system] = "B"
            && 'table'[label] = "Blocker"
    ),
    'table'[points]
)

Best Regards,
Dangar

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