Analyzing the performance of DISTINCTCOUNT in DAX

Analyzing the performance of DISTINCTCOUNT in DAX

The VertiPaq engine is used by DAX when you query a model based on data loaded in memory. The performance of the Vertipaq engine is also outstanding when it counts unique values in a column using the DISTINCTCOUNT function. However, counting unique values in complex...