Total Cost

Now let's create the Total Cost measure. Once again, this is a simple SUM operation. Click New Measure... from the modeling ribbon and type in the following DAX formula:

Total Cost = SUM('Internet Sales'[Total Product Cost])

Remember to apply formatting to this new measure; it is easy to miss this step when learning to create measures. The formatting should be $ English (United States).

Get Microsoft Power BI Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.