Forum Discussion
Solved
Distinct Count Optimized when Filtered
I have a simple DAX query counting distinct ID's in a fact table. When I run a simple 'Distinctcount(ID)....I get the answer in 7ms. However...I need to run a distinct count on ID's where fact[colu...
Hi codyraptor
Please refer to
My guess is that the first result is sourcing the answer from metadata. Once you apply a filter, it has to do the actual count. It's only a guess.