sumx a table with multiple values code example

Example: power bi sum with filter

Sum = CALCULATE(SUM(Qty);FILTER(Status=C))