Question 320
A KPI should count each transaction row, including repeated customers. What is the MOST appropriate Power BI design decision?
Explanation
Correct Answer
COUNTROWS counts records in the filtered fact table rather than distinct identifiers. It meets the scenario requirement of filtered transaction event count.
Incorrect Answers
SUM aggregates numeric fact values within the current filter context. It would instead address additive filtered revenue metric, not the stated filtered transaction event count.
DISTINCTCOUNT avoids counting multiple transactions for the same customer as separate buyers. It may be appropriate for unique purchasing customer count, whereas the current need is filtered transaction event count.
AVERAGE calculates the mean of eligible numeric values in filter context. This solves context-sensitive average satisfaction, not the requested filtered transaction event count.






Microsoft Power BI Data Analyst (PL-300) Practice Tests