dax sum column when filtered value is TRUE example Example: power bi sum with filter Sum = CALCULATE(SUM(Qty);FILTER(Status=C))