Total Sum is not as expected or DAX formula is wrong

[Anonymous]

I have following table:

I want to show only those brands with more than 2 distinct articles and sum the value for those.

Here is my approach:

Z_DistCount = CALCULATE(SUM(Table1[Sales]); FILTER(Table1;DISTINCTCOUNT(Table1[Articles])>2))

Values look fine, but the total is messed up, expecting 485, instead of 699.

I suspect it has something to do with hasonevalue() , following

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376 

however, having trouble to adapt.

Alternatively,

Z_DistCount_sumx = SUMX(FILTER(Table1;DISTINCTCOUNT(Table1[Articles])>2);Table1[Sales])

has the same outcome as first formula above.

Any ideas?

[v-lili6-msft · Accepted solution]

hi @Anonymous 

Just try this formula as below:

Measure = 
CALCULATE(SUM(Table1[Sales]), FILTER(VALUES(Table1[Brand]),CALCULATE(DISTINCTCOUNT(Table1[Articles]))>2))

Result:

 

Regards,

Lin