Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |