Business Intelligence: Understanding Distinct Count in DAX Query Plans

Distinct Count calculations in DAX are very fast compared to other engines. But when you have a large number of values, performance might be different depending on the query you write.

Distinct Count calculations in DAXIn this paper you will read about different techniques that produce the same result with different performance, showing that you need to make your homework in order to find the right optimization for your model, explaining how to read query plans and how to choose the best solution for your model.

BI+SQL Server 2016 = sant

Uppdatera dig!

Ta med dig dina BI-kunskaper till  SQL Server 2016.