Forum Discussion
Sumifs on Single table
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
CALCULATE(SUM(Table[Sales]),ALLEXCEPT(Table,Table[Product],Table[Region]))
2 Replies
CALCULATE(SUM(Table[Sales]),ALLEXCEPT(Table,Table[Product],Table[Region]))