PL-300 • Practice Test 37
Free PL-300 practice test — 15 questions with explanations. Set 37. No signup required.
You run the above DAX query in DAX Studio. The result shows profit margin values for each year, but all values are the same for every year despite sales amounts varying. What is the most likely cause?
Refer to the exhibit.
```dax
DEFINE
MEASURE Sales[Total Sales] = SUMX(Sales, Sales[Quantity] * Sales[Unit Price])
MEASURE Sales[Total Cost] = SUMX(Sales, Sales[Quantity] * Sales[Unit Cost])
MEASURE Sales[Profit Margin] = DIVIDE([Total Sales] - [Total Cost], [Total Sales])
EVALUATE
SUMMARIZECOLUMNS(
'Date'[Year],
"Sales Amount", [Total Sales],
"Profit Margin %", [Profit Margin]
)
ORDER BY 'Date'[Year]
```