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 4 months, 2 weeks 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 13 times

SylUK

3 months, 1 week 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

...

Mkymp

Most Recent 1 week, 2 days ago

CALCULATETABLE is invalid here because: It returns a table, not a single value Measures can’t return a table // Sales = ... ``That means you need a **scalar value** like `SUM`, `COUNT`, etc. to be returned. - You're modifying the context to only include rows where `'Unit'[Color] = "blue"` - You want to sum up sales — i.e., return a number So you use: ```dax CALCULATE ([Sales], KEEPFILTERS('Unit'[Color] = "blue")) That would be my answer.

upvoted 1 times

...

Jasmine121

3 months, 1 week ago

should be calculatetable()

upvoted 1 times

...

fehler

4 months 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

...