Question

You are analyzing a Fabric semantic model using a DAX query in the Fabric portal's DAX query view. You need to return a single-column table containing the distinct list of product category names from the 'Product' table, but only for products where the 'Discontinued' column equals FALSE. Which DAX expression should you use?

Accepted Answer

EVALUATE CALCULATETABLE(VALUES('Product'[Category]), 'Product'[Discontinued] = FALSE)

Answer

EVALUATE FILTER(VALUES('Product'[Category]), 'Product'[Discontinued] = FALSE)

Answer

EVALUATE SUMMARIZE('Product', 'Product'[Discontinued])

Answer

EVALUATE DISTINCT('Product'[Discontinued])