March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hey all I have an issue where distinctcount does not seem to be giving me the right results.
I have two tables (a & b) with b being a duplicate of a. I have written a measure for both tables to count the unique ids (see below).
Triggers = DISTINCTCOUNT(a[RECOMMENDATION_ID])
I am not sure why b is return the 541k result. Moreover, when I look at the table b in the "table view" and highlight the recommendation_ID column, it is giving me the correct distinct count - see below +1 added on purpose.
I've been searching for the last two days for a solution with no luck. Any help would be appriciated as I am stumped. Thanks.
I am not sure why Distinct count would be more than Count all?
How can 1881631 would be distinct count ?
Hi @S13 ,
Could there be a filter on the visual/page/report? Otherwise, do you have the possibility to share your file? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Thanks for the reply. There is no filter on the page/report/visual. Unfortunatly it is a work related project and cannot share the file... wish I could though since I feel like it's probably something simple that I am over looking.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
87 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |