Question

You are an analytics engineer working in a Fabric semantic model. Business analysts need an ad hoc result set that returns total sales amount grouped by product category and calendar year, but only for rows where the sales amount is greater than zero. You want to write a single DAX query in the DAX query view of the model that produces this grouped, filtered aggregation efficiently. Which DAX function should form the basis of your query?

Accepted Answer

SUMMARIZECOLUMNS, using the category and year columns as groupings with a filter expression and a named measure for total sales

Answer

CALCULATETABLE wrapped around the entire fact table to pre-filter every row before display

Answer

ADDCOLUMNS over the full fact table to append a running total for each transaction

Answer

TOPN to return the highest-value sales rows without any grouping