SUMX(VALUES(column), [Measure]) returns parent-level value, while ADDCOLUMNS/SUMMARIZECOLUMNS works

I found the root cause.

The issue was caused by the semantic model setting Value filter behavior. In my case, this setting changed how filters were evaluated in the visual context, which is why SUMX(VALUES(...), [Measure]) produced unexpected parent-level repeated values.

This also explains why:

• adding hierarchy columns changed the result
• alternative patterns such as ADDCOLUMNS / SUMMARIZECOLUMNS behaved differently

So the problem was not the base measure itself, but the semantic model's Value filter behavior setting.

Here`s the documentation.I'm mistaken. The default value hasn't changed. I remember it's changed.I can't believe it's still on the preview

Work with value filter behavior in Power BI - Power BI | Microsoft Learn