dax calculate sum filter code example Example: power bi sum with filter Sum = CALCULATE(SUM(Qty);FILTER(Status=C))