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

me@jaykilleen.com wrote this almost 8 years ago and it was last updated almost 8 years ago.

power-bi

← Back to the Posts


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

Similar

Add Dynamic Role Level Security to PowerBI Using an Attribute of the Current User

Add Dynamic Role Level Security to PowerBI using current users email

Create a Simple Empty Table in Power Query with Code Example

Add a Date Model to PowerBI or Power Query

Writing a Blog Post About M Lang/M Language/Power Query Formula Language/Power BI/Get & Transform

Connect PowerBI to a Remote PostgreSQL Database Encrypted with SSL

Simple Power Query M to Display When the Report was Last Refreshed

Display a SQL Server Table Schema in PowerBI

Turning On Fast Combine in Power BI to enable Personal Gateway Data Refresh

Tiny Tweaks Needed for the Power Query Editor

Implementing an Environment Parameter in Power BI to Improve Performance in Development

Managing Queries in PowerBI and Power Query using Git

CountIF in PowerBI DAX

Add a DateKey Column in PowerBI M Lang

Loading M Queries from the Web into Power BI

Single and Multi Line Comments in Power Query Advanced Editor

Countif in Power Query or Powerbi using M Language