Question

An analyst is building a measure for a Power BI report on a Fabric semantic model. The requirement is: return the total sales contributed only by the top 5 products (by their own total sales) within the current filter context, and the measure must respond correctly when a category or year slicer is applied. Which DAX pattern produces the correct result?

Accepted Answer

CALCULATE(SUMX(TOPN(5, VALUES(Product[ProductKey]), [Total Sales], DESC), [Total Sales]))

Answer

CALCULATE([Total Sales], TOPN(5, ALL(Product), [Total Sales], DESC))

Answer

SUMX(TOPN(5, ALL(Product[ProductKey]), [Total Sales], DESC), [Total Sales])

Answer

TOPN(5, [Total Sales], Product[ProductKey])