Question 19 of 388
Single answerYou plan to create the chart shown in the following exhibit. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
ACreate a horizontal line that has a fixed value of 24,000.
BAdd a measure to the visual that uses the following DAX expression.Heasurel -PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)
✓CAdd a new percentile line that uses Total Sales as the measure and 40% as the percentile.
DAdd a measure to the visual that uses the following DAX expression.Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
✓
Correct Answer: C
Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.