100% Latest & Updated Microsoft PL-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 250
A report needs regional revenue calculated under an explicit Sales[Channel] filter. The selected approach is: Use CALCULATE to evaluate a measure in modified filter context. Which implementation step puts it into practice?
- Select the last available reporting date and evaluate the balance at that date.
- Create a calculated column = RELATED(Product[Category]) with the relationship present.
- Assign meaningful variables before the RETURN expression.
- Define CALCULATE([Sales], Sales[Channel] = "Online").
Explanation
Correct Answer
D:The added channel condition controls the evaluated rows.
Incorrect Answers
A:The measure should use the relevant final snapshot for a period. It does not implement the needed solution: use calculate to evaluate a measure in modified filter context.
B:Row context plus relationship allows lookup of dimension values. It does not implement the needed solution: use calculate to evaluate a measure in modified filter context.
C:The final result can reuse scalar or table values consistently. It does not implement the needed solution: use calculate to evaluate a measure in modified filter context.
Question 251
A manager wants sales amount for online orders only, while keeping all other report slicers active. The chosen solution is: Use CALCULATE to evaluate a measure in modified filter context. Which TWO actions together implement this approach and provide evidence that it works? Choose TWO.
- Define CALCULATE([Sales], Sales[Channel] = "Online").
- Assign meaningful variables before the RETURN expression.
- Ask report authors to locate core KPIs without seeing irrelevant identifiers.
- Test the derived attribute against sample source rows.
- Compare filtered results with manually filtered source records.
Explanation
Correct Answers
A:The added channel condition controls the evaluated rows.
E:The measure should isolate online orders within other applicable filters.
Incorrect Answers
B:The final result can reuse scalar or table values consistently. It does not implement the needed solution: use calculate to evaluate a measure in modified filter context.
C:Usability improves when the model exposes fewer technical details. That check does not verify the result required here: compare filtered results with manually filtered source records.
D:Row-level classification should be reproducible. That check does not verify the result required here: compare filtered results with manually filtered source records.
Question 252
A manager wants sales amount for online orders only, while keeping all other report slicers active. A specific ongoing problem has appeared: A filter replacement might override a user's existing selection on the same column. Which safeguard most directly addresses it?
- Name and test date-role measures and relationships explicitly.
- Test folding after substantive query edits.
- Use explicit filter semantics when combining slicer and measure conditions.
- Check unique dimension keys before enabling the relationship.
Explanation
Correct Answer
C:CALCULATE can replace same-column filters unless intersection is requested.
Incorrect Answers
A:Clear date roles prevent misleading calendar analytics; CALCULATE can replace same-column filters unless intersection is requested.
B:The physical execution plan can change with transformations. CALCULATE can replace same-column filters unless intersection is requested.
D:Accidental many-to-many modeling often signals a data quality or grain error. CALCULATE can replace same-column filters unless intersection is requested.
Question 253
A marketing measure needs to add a product-category condition without erasing an existing category selection. Which Power BI approach most directly satisfies this requirement?
- Use DISTINCTCOUNT on the intended business identifier.
- Use KEEPFILTERS to intersect filters on the same column.
- Use SUMX for a row-wise expression before aggregating.
- Use a calculation group to reuse common time calculations where supported.
Explanation
Correct Answer
B:KEEPFILTERS changes CALCULATE filter handling to preserve intersections.
Incorrect Answers
A:DISTINCTCOUNT avoids treating multiple line rows as separate business entities. KEEPFILTERS changes CALCULATE filter handling to preserve intersections.
C:SUMX iterates visible rows and sums an expression evaluated for each row. KEEPFILTERS changes CALCULATE filter handling to preserve intersections.
D:Calculation groups apply reusable transformations to selected measures; KEEPFILTERS changes CALCULATE filter handling to preserve intersections.
Question 254
A BI team wants to intersect a DAX measure's segment filter with user slicers on the same segment. The selected approach is: Use KEEPFILTERS to intersect filters on the same column. Which implementation step puts it into practice?
- Create appropriate calculation items using SELECTEDMEASURE and time filters.
- Assign meaningful variables before the RETURN expression.
- Wrap the CALCULATE filter argument with KEEPFILTERS.
- Define SELECTEDVALUE(Region[Name], "Multiple regions").
Explanation
Correct Answer
C:The measure should narrow rather than overwrite an existing selection.
Incorrect Answers
A:Reusable items can apply to many base measures when configured correctly. It does not implement the needed solution: use keepfilters to intersect filters on the same column.
B:The final result can reuse scalar or table values consistently. It does not implement the needed solution: use keepfilters to intersect filters on the same column.
D:An alternate handles zero or many selections. It does not implement the needed solution: use keepfilters to intersect filters on the same column.
Question 255
A marketing measure needs to add a product-category condition without erasing an existing category selection. The chosen solution is: Use KEEPFILTERS to intersect filters on the same column. Which verification best demonstrates that it meets the requirement?
- Test conflicting and matching slicer selections.
- Compare model memory and report results after the change.
- Inspect query folding and compare refresh time after the change.
- Compare selected-date totals for the two date-role measures.
Explanation
Correct Answer
A:An intersection may legitimately return blank when filters conflict.
Incorrect Answers
B:Storage savings should not remove required relationships or metrics. That check does not verify the result required here: test conflicting and matching slicer selections.
C:Folded filters should improve refresh efficiency. That check does not verify the result required here: test conflicting and matching slicer selections.
D:The two measures should differ when order and shipment dates differ. That check does not verify the result required here: test conflicting and matching slicer selections.
Question 256
A marketing measure needs to add a product-category condition without erasing an existing category selection. A specific ongoing problem has appeared: A report can show unexpected totals if filters are overwritten. Which safeguard most directly addresses it?
- Avoid unnecessary high-cardinality calculated columns.
- Retain necessary iterators for true row-level arithmetic.
- Review relationship diagrams whenever the model changes.
- Document measure filter replacement versus intersection behavior.
Explanation
Correct Answer
D:Choice of filter semantics affects user trust.
Incorrect Answers
A:Storing many per-row values consumes memory; choice of filter semantics affects user trust.
B:Do not sacrifice correctness for superficial expression simplicity. Choice of filter semantics affects user trust.
C:Model structure is central to DAX correctness; choice of filter semantics affects user trust.
Question 257
A card needs total company revenue regardless of which product is selected, but must preserve date filters. Which Power BI approach most directly satisfies this requirement?
- Remove only Product filters in the denominator using REMOVEFILTERS.
- Use DISTINCTCOUNT on the intended business identifier.
- Use COUNTROWS to count table records.
- Use VAR and RETURN to name reusable intermediate values.
Explanation
Correct Answer
A:Targeted filter removal preserves other report context.
Incorrect Answers
B:DISTINCTCOUNT avoids treating multiple line rows as separate business entities; targeted filter removal preserves other report context.
C:COUNTROWS counts rows in the visible table regardless of a particular column's blank values. Targeted filter removal preserves other report context.
D:Variables make measures easier to read and can avoid repeated computation; targeted filter removal preserves other report context.
Question 258
A percent-of-product-total measure needs the denominator across all products for the currently selected year. The selected approach is: Remove only Product filters in the denominator using REMOVEFILTERS. Which implementation step puts it into practice?
- Define SUMX(Sales, Sales[Quantity] * Sales[UnitPrice]).
- Define Ticket Count = COUNTROWS(Tickets).
- Define Order Count = DISTINCTCOUNT(Sales[OrderID]).
- Use CALCULATE([Revenue], REMOVEFILTERS(Product)) for the denominator.
Explanation
Correct Answer
D:The Product selection is ignored for the total while other filters remain.
Incorrect Answers
A:Per-row multiplication occurs before aggregation; multiplying column sums would differ. It does not implement the needed solution: remove only product filters in the denominator using removefilters.
B:The measure respects filter context for the table. It does not implement the needed solution: remove only product filters in the denominator using removefilters.
C:The count follows the selected rows while counting unique IDs. It does not implement the needed solution: remove only product filters in the denominator using removefilters.
Question 259
A card needs total company revenue regardless of which product is selected, but must preserve date filters. The chosen solution is: Remove only Product filters in the denominator using REMOVEFILTERS. Which verification best demonstrates that it meets the requirement?
- Test historical and current joins for correct transaction attribution.
- Test counts across students, courses and unique memberships.
- Test the derived attribute against sample source rows.
- Change product slicers and verify the denominator stays fixed for the same year.
Explanation
Correct Answer
D:Correct denominator semantics are important for percentages.
Incorrect Answers
A:The model should match the appropriate version or current value. That check does not verify the result required here: change product slicers and verify the denominator stays fixed for the same year.
B:Relationships must not multiply memberships when filtering. That check does not verify the result required here: change product slicers and verify the denominator stays fixed for the same year.
C:Row-level classification should be reproducible. That check does not verify the result required here: change product slicers and verify the denominator stays fixed for the same year.
Question 260
A card needs total company revenue regardless of which product is selected, but must preserve date filters. A specific ongoing problem has appeared: Removing all filters could ignore required time or security context. Which safeguard most directly addresses it?
- Scope filter-removal expressions to the intended dimension.
- Validate uniqueness at the chosen effective-dated key.
- Refresh and validate the date table range for the reporting horizon.
- Keep a governed detailed source separately if deeper drilldown is required.
Explanation
Correct Answer
A:Broad ALL-table removal can change more context than required.
Incorrect Answers
B:Versioned dimensions require consistent key strategy. Broad ALL-table removal can change more context than required.
C:Coverage must include all required periods; broad ALL-table removal can change more context than required.
D:Granularity reduction trades detail for performance. Broad ALL-table removal can change more context than required.
Microsoft Power BI Data Analyst (PL-300) Practice Tests