You have a Sales table where the same SalesOrderNumber can appear on multiple rows (for different line items). Which function counts the number of unique sales orders?

Question

Answer

COUNT(Sales[SalesOrderNumber]), although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.

Answer

COUNTROWS(Sales), however, this wording confuses row context, filter context, or evaluation timing and therefore misses the exact DAX behavior being tested.

Answer

DISTINCTCOUNT(Sales[SalesOrderNumber])

Answer

SUM(Sales[SalesOrderNumber]), although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.

Answer

A syntax-level statement that appears valid but actually describes iterator usage in a context where scalar evaluation is required

Crowdly

You have a Sales table where the same SalesOrderNumber can appear on multiple...

Want instant access to all verified answers on learning.devinci.fr?