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. This paper investigates 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.