Forum Discussion
Count(distinct) not working
Community Championavujica - The built-in distinct count works for me. See attached PBIX below sig. You want table 3 page 3
Hi Thank you for lookinbg at my problem and offering a solution unfortunately its not working as intended. Please note my observation documente din my most recent post in this thread.
Thank you again for your help,
Alan
- edhans
avujica hover over the filter icon on the visual when i the desktop and confirm it is filtered as you think it is. I've filter panes and off-paged syncing with hidden slicers on current page messing with filters during DAX debugging.
Other than that, you will need to share something with us. You can have filtering happening depending on your filter relationships. Bi-directional possibly, but Many to many will mess with this. Otherwise it will be very difficult for any of us to figure out the problem by your description alone. On its own, DISTINCTCOUNT() is a pretty basic function, so anything going wrong is a filter or modeling issue, or both.
