|Task| DAX Measures

Steps:

  1. Create a measure to show Total Sales
  2. Create A DAX Measure named USA Sales to show all sales made in USA
  3. Create A DAX Measure named Non USA Sales to show all sales made outside the USA
  4. Create A DAX Measure named Last Year Sales to show the Previous Year Sales
  5. Create A DAX Measure named YoY% to show the percent of Year over Year growth (% difference)
  6. Create A DAX Measure(s) named Total Profit to show Profit (Total Sales – Cost of Goods Sold) Note: to find Cost of goods sold you must multiply [Cost of Goods] by [Price] – on a row by row basis. In our example the Cost of goods is a percentage of the Sales column. So if a single row has a Sales price of $100 and the Cost Of Goods = 0.8, our actual cost of goods would be $100 * 0.8 = $80. Meaning we would make $20 Revenue on the sale of this single product.
Complete and Continue