PL-300 Question 79

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  Statement 1: 51 rows In Power BI table visuals, when a field's Summarize by property is set to None, Power BI groups the table by unique/distinct values. Because there are 51 unique values in UnitsInStock, the visual displays 51 distinct rows. Statement 2: Reduce Changing Summarize by to an aggregation method (such as Sum, Average, or Count) aggregates all values across the column into a single summarized total row, reducing the row count in the visual.

• 1

  75 maintain Changing Summarize by (e.g., Sum, Average, Min, Max) only affects how the value is aggregated, not how many rows appear. A table visual only reduces rows if you remove the product-level detail — but you’re still adding UnitsInStock as a field, so: The table still shows one row per product The number of rows stays 75 So the correct choice is maintain.

• 1

  noooo correct answer is: 75, reduce “Changing the Summarize by setting of the UnitsInStock column, and then adding the column to a table visual, will … the number of rows in the table visual.” - If you change Summarize by (e.g., to Sum), Power BI will aggregate values instead of showing every row. - Aggregation reduces the number of rows displayed, because multiple rows collapse into grouped totals.