Sumifs on Single table

[Anonymous]

Hi There,

I've been trying to do sumifs using Calculate(SUM(),FILTER()) Dax on a single table but I'm getting the whole total sum from the table. Here's the full computation I used if this will be computed via Excel. Please help advise best Dax formula to use. Thank you

[Anonymous]

Thanks for the prompt response. It worked 🙂

[wdx223_Daniel · Accepted solution]

CALCULATE(SUM(Table[Sales]),ALLEXCEPT(Table,Table[Product],Table[Region]))