Which four actions should you perform in sequence?

You 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?
A. Add a measure to the visual that uses the following DAX expression.
Measure1 = PERCENTILEX.INC (Sales,Sales[Total Sales],0.40)
B. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
C. Create a horizontal line that has a fixed value of 24,000.
D. Add a measure to the visual that uses the following DAX expression.
Measure1 = PERCENTILEX.EXC (Sales,Sales[Total Sales],0.40)

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.