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)

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.226.165.70