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

10 months ago

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

upvoted 0 times

...

Alita

10 months ago

Wait, how can we be sure about the value?

upvoted 0 times

...

Raymon

10 months ago

Definitely going with option C, 35 seems right!

upvoted 0 times

...

Allene

10 months ago

I think the Previous Year measure will show 15.

upvoted 0 times

...

Skye

10 months ago

The active relationship is between DimDate and FactSales.

upvoted 0 times

...

Merissa

11 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

11 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

11 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

11 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

11 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

11 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

11 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

11 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

11 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

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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

2 years ago

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

upvoted 0 times

...

Crista

2 years 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

2 years 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

2 years 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

2 years ago

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

upvoted 0 times

...

Vernell

2 years ago

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

upvoted 0 times

...

Asuncion

2 years ago

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

upvoted 0 times

...

Sherly

2 years ago

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

upvoted 0 times

...

Rikki

2 years 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

2 years 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