Exam PL-300 topic 2 question 105 discussion

Actual exam question from Microsoft's PL-300

Question #: 105
Topic #: 2

HOTSPOT
-

You have a Power BI semantic model named Model1.

You need to create a measure that will display the sales result for all blue units. The solution must maintain the existing filter context.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Odidepse at Jan. 14, 2025, 8:15 a.m.

Comments

Submit Cancel

Odidepse

Highly Voted 3 months, 1 week ago

I would go for CALCULATE and KEEPFILTERS. CALCULATE evaluates a single expression (like [Sales]) within a modified filter context. In this scenario case, you want to filter the 'Unit'[Color] to "blue" while maintaining the existing filter context. CALCULATETABLE would return a table, which would then need to be aggregated further (e.g., using SUMX), making it less direct and has a layer of complexity. Second one , use KEEPFILTERS is the most appropriate for ensuring that the filter for blue is added to the existing context without overriding it.

upvoted 12 times

SylUK

2 months ago

Look at the syntax structure it is CALCUTETABLE which can by applied here because it evaluates a table within a modified filter context. Therefore the answers are CALCULATETABLE and KEEPFILTERS.

upvoted 1 times

...

Jasmine121

Most Recent 2 months ago

should be calculatetable()

upvoted 1 times

...

fehler

2 months, 3 weeks ago

Sales_Blue_Units = CALCULATE( SUM(Sales[SalesAmount]), KEEPFILTERS(Products[Color] = "Blue") ) So in this case I believe we need to assume SUM is present, because after "=" should be CALCULATE

upvoted 2 times

...

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam