Question

An analyst builds a semantic model with a Sales fact table and a Customer dimension. Management wants a measure that counts customers who purchased in the current filter context but excludes any customer whose total sales fell below a $500 threshold. The measure must respect all report slicers (region, year). Which DAX expression correctly returns this count?

Accepted Answer

COUNTROWS(FILTER(VALUES(Customer[CustomerKey]), [Total Sales] >= 500))

Answer

CALCULATE(DISTINCTCOUNT(Customer[CustomerKey]), Sales[Amount] >= 500)

Answer

COUNTROWS(FILTER(ALL(Customer[CustomerKey]), [Total Sales] >= 500))

Answer

SUMX(VALUES(Customer[CustomerKey]), IF([Total Sales] >= 500, [Total Sales], 0))