Microsoft PL-300 Exam - 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

Arlyne

3 months ago

I agree with Allene, 15 makes sense for last year!

upvoted 0 times

...

Alita

3 months ago

Wait, how can we be sure about the value?

upvoted 0 times

...

Raymon

4 months ago

Definitely going with option C, 35 seems right!

upvoted 0 times

...

Allene

4 months ago

I think the Previous Year measure will show 15.

upvoted 0 times

...

Skye

4 months ago

The active relationship is between DimDate and FactSales.

upvoted 0 times

...

Merissa

4 months ago

I feel like the answer could be 15, but I might be mixing it up with another question we did on sales trends.

upvoted 0 times

...

Telma

5 months ago

If the filter is set to May 9, 2024, then the Previous Year measure would reference May 9, 2023. I just can't recall the exact value from the data.

upvoted 0 times

...

Cherry

5 months ago

I think we practiced a similar question where we had to calculate previous year sales, and it was based on the active relationship between the tables.

upvoted 0 times

...

Fannie

5 months ago

I remember that the Previous Year measure should calculate the value from the same date last year, but I'm not completely sure how it interacts with the page level filter.

upvoted 0 times

...

Joana

5 months ago

I feel pretty confident about this one. The information provided gives me a good understanding of how to approach the problem.

upvoted 0 times

...

Derick

5 months ago

This seems straightforward enough. I just need to visualize the data and the measure logic to determine the correct answer.

upvoted 0 times

...

Rikki

5 months ago

I'm a bit confused by the date table and relationship details. Let me re-read that part and make sure I understand how that impacts the measure calculation.

upvoted 0 times

...

Lindsey

5 months ago

Okay, I think I've got this. The key is understanding how the Previous Year measure is calculated based on the date filter.

upvoted 0 times

...

Christiane

5 months ago

Hmm, this looks like a tricky one. I'll need to carefully read through the details and think through the logic step-by-step.

upvoted 0 times

...

Markus

1 year 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

1 year 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

1 year 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

1 year 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

1 year 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

1 year ago

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

upvoted 0 times

...

Crista

1 year 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

1 year 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

1 year 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

1 year ago

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

upvoted 0 times

...

Vernell

1 year ago

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

upvoted 0 times

...

Asuncion

1 year ago

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

upvoted 0 times

...

Sherly

1 year ago

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

upvoted 0 times

...

Rikki

1 year 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

1 year 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