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