Columns Feed Measures
Part of the Power BI Basics section of Coddy's Power BI journey. Lesson 25 of 28.
A measure can aggregate a calculated column like any other column.
Gross Sales = SUM(Sales[Line Total])Line Total is the price before discount, Amount what was paid; the gap is the member discount.
The column works per row once; the measure sums it per bar.
Challenge
The model has the column Sales[Line Total]. Write a measure Discount Given: the sum of Line Total minus the sum of Amount. It is checked for each Customers[Segment].
All lessons in Power BI Basics
1Meet Power BI
What Power BI IsTables, Rows and ColumnsYour First ChartSum, Count and AverageFilters and SlicersRecap - Mia's First Report4Calculated Columns
Columns vs MeasuresIF in a ColumnText ColumnsLooking Up with RELATEDColumns Feed MeasuresProfit and MarginWhen to Use WhichRecap - Profit by Category