Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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[column] <> 'XX'. My calculation jumps to 700ms once a filter is applied. I've tried applying the filter on the fact table as well as on the DIM table (1 to many)....but can't seem to optimize and get the initial speed. Any thoughts? I've read the sqlbi paper on distinct count...but I don't see anything specific to applying filters in the calculation.
Solved! Go to Solution.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
15 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |