In this Video, I’ll create a DAX (Data Analysis eXpression) Measure. This measure will be used to calculate the total sales price. Check out this video to see how to create a measure that performs “Aggregation with Iteration”; which is a fancy way of saying DAX needs to calculate the total sales price for each row, then sum it together. Look at the two examples below and you’ll see why.

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure. This measure will be used to calculate the total sales price. Check out this video to see how to create a measure that performs “Aggregation with Iteration”; which is a fancy way of saying DAX needs to calculate the total sales price for each row, then sum it together. Look at the two examples below and you’ll see why.

Continue reading “Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI”