Forum Discussion
DISTINCTCOUNT with filter condition doesn't work
Hi Anonymous ,
You have a typo in your measure my friend!
You wrote "Tradesman", it should be "Tradesmen".
Cheers,
Fernando
Unfortunately, I can't share the file since it has sensitive information. What I can do it to post a snapshot of my table where you can see one row with the CompanyCategory = "Tradesmen":
I expect to see a numbe 1 in the Card becasue for a distinct count of the empoyees there is only one row that matches the filtering condition.
I have to appologize for my post. This was a simple typo: "Tradesman" instead of a "Tradesmen". This forced me to do a more thorough work when I encounter issues like this.
- calerof
Impactful Individual
Hi Anonymous ,
No worries, this forum is to help users in the community.
Just mark the question answered if you agree.
Regards,
Fernando