SumIFS in Power BI DAX Using Current Row Value as Filter

Simply sum the quantity using a field from the current row as a filter in the table you are summing from wrote this over 4 years ago and it was last updated over 4 years ago.

← Back to the Posts

  TotalQuantity = CALCULATE(SUM(Sales[Quantity]), FILTER(Sales, Sales[CustomerId] = EARLIER (Sales[CustomerId])))