Microsoft Exam PL-300 Topic 4 Question 55 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 55
Topic #: 4

You have a Power BI semantic model named Model1 that contains two table named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data.

Model1 contains the following measure:

You have a report that uses Model1. The report has a single report page that has a page level filter set to may 9, 2024. The result of the Previous Year measure is displayed in a card visual.

Which value appear in the card visual?

A10

B15

C35

D60

Show Suggested Answer

Suggested Answer: B

by Evette at Sep 16, 2024, 12:02 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Markus

10 months ago

Ah, the classic 'previous year' measure question. I'm going to have to go with option C) 35. It just makes the most sense based on the information provided.

upvoted 0 times

Melissa

9 months ago

I see your point, but I'm sticking with option C) 35. It seems like the most logical choice given the context of the question.

upvoted 0 times

...

Kanisha

9 months ago

I disagree, I believe it's option D) 60. The measure calculates the sum of sales for the previous year, so it should be 60 based on the data shown.

upvoted 0 times

...

Jeannetta

10 months ago

I think it's actually option B) 15. The date filter is set to May 9, 2024, so it should show the previous year's sales for that date.

upvoted 0 times

...

Taryn

10 months ago

I'm not sure about this one. Can someone explain why the answer is 15 and not any other option?

upvoted 0 times

...

Cordelia

10 months ago

I agree with Sherly. The Previous Year measure would show the value from the previous year, which is 15.

upvoted 0 times

...

Crista

10 months ago

Haha, this question is a real head-scratcher! I'm going to guess option B) 15, just to see if I can throw everyone off. But seriously, I think the correct answer is 35.

upvoted 0 times

...

Hubert

10 months ago

This is a tricky one. I'm going to go with option C) 35. The measure is calculating the previous year's sales, and the page-level filter is limiting the data to a specific date, so the answer should be the previous year's sales for that date.

upvoted 0 times

Scarlet

9 months ago

Let's test it out and see if we can confirm the correct answer. It's always good to double-check.

upvoted 0 times

...

Merlyn

9 months ago

That's a good point. The filter could be changing the context of the calculation. We should consider that.

upvoted 0 times

...

Vernell

9 months ago

But what if the filter affects the calculation differently? Maybe it's not as straightforward as we think.

upvoted 0 times

...

Asuncion

9 months ago

I think you might be right. Option C) 35 seems like the most logical choice.

upvoted 0 times

...

Sherly

10 months ago

I think the answer is B) 15 because it's the result of the Previous Year measure.

upvoted 0 times

...

Rikki

11 months ago

I'm pretty sure the answer is 60. The measure is calculating the previous year's sales, and since the report has a page-level filter, it's only considering the data for that specific date.

upvoted 0 times

...

Pamella

11 months ago

Hmm, let me think about this. The measure is calculating the previous year's sales, and the report has a page-level filter set to May 9, 2024. So, the answer must be the previous year's sales for that specific date, which is 35.

upvoted 0 times