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 c...
CALCULATE(SUM(Table[Sales]),ALLEXCEPT(Table,Table[Product],Table[Region]))
CALCULATE(SUM(Table[Sales]),ALLEXCEPT(Table,Table[Product],Table[Region]))