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 measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.EXC (Sales,sales[Total Sales],0.40)
C.
Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
D.
Create a horizontal line that has a fixed value of 24,000.
Haven't even thought about the DAX expressions and whether they are returning expected percentile (anyway I think it would be a "dynamic" result based on the context and not a constant total value to be used across the visual). We have set of calculated lines we can use without defining any DAX expression
Actually I do not know the difference between "Percentile line" and "Percentile.INC()" , but I know "percentileX.inc()" has row filter and it will not be horizontal.
Let's say that on a particular day, the daily sales range from $100 to $1,000, with the 40th percentile being $300. However, if you calculate the total sales for the same day by adding up the sales from all transactions, the range may be much wider, say from $1,000 to $10,000, with the 40th percentile being $3,000. While both percentiles represent the same percentage of the total sales or transactions, the 40th percentile of daily sales may be a better indicator of the typical or median level of sales for that day, as it takes into account the variability and distribution of sales across individual transactions.
Therefore, when adding a percentile line to a visualization, it's important to consider which measure and which percentile are most relevant and informative for the specific context and analysis, and to use the appropriate function (e.g., PERCENTILEX.INC or PERCENTILEX.EXC) to calculate the percentile based on the desired interpretation and inclusion/exclusion of values.
So Correct ans is A , since we want to include 40th percetile of the sales of the day and show the dashed horizontal. It wont be straight line but a curved one
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
jaume
4 days, 16 hours agorcaliandro
3 months, 1 week agoSuraj97
1 year agoTime2excel
1 year, 4 months agoJJMC5544
1 year, 5 months agoHink
1 year, 6 months agoShalaleh
1 year, 6 months agoShalaleh
1 year, 7 months agosa56
1 year, 7 months agosa56
1 year, 7 months agoShalaleh
1 year, 7 months agocsillag
1 year, 11 months agojboiret
1 year, 11 months agoslash_nyk
1 year, 11 months agolukelin08
2 years, 1 month agomkthoma3
2 years, 1 month agoEMMALEEEEEEEEE
2 years, 2 months agoMRT_17
2 years, 1 month agoSnow_28
2 years, 2 months agoEMMALEEEEEEEEE
2 years, 2 months agoLuffy561
2 years, 1 month agorehoboth2165
2 years ago