Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
We have a formula measure field with the following distinct count formula in it:
@krichmond Try using ALLSELECTED instead of ALL or perhaps ALLEXCEPT
@Greg_Deckler - I tried the "ALLSELECTED" approach and it didn't work. The distinct count still stays the same even with a filter applied. The "ALL EXCEPT" generated an error.
User | Count |
---|---|
81 | |
76 | |
70 | |
69 | |
54 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |