SUMX working correctly for one label, but not the other

Anonymous — Mon, 30 Sep 2024 16:52:03 GMT

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!

Re: SUMX working correctly for one label, but not the other

Dangar332 — Mon, 30 Sep 2024 18:05:46 GMT

Hi, Anonymous

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.

topic Re: SUMX working correctly for one label, but not the other in DAX Commands and Tips

SUMX working correctly for one label, but not the other

Re: SUMX working correctly for one label, but not the other