Forum Discussion
DISTINCTCOUNT with filter condition doesn't work
Hello all, I am sort of new to Power BI. I just took a Microsoft Power BI online class. I am tryining to do a simple calculated measure. I want to count all distinct employeeids who's CompanyCat...
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.
calerof
Impactful Individual
Impactful IndividualHi Anonymous ,
You have a typo in your measure my friend!
You wrote "Tradesman", it should be "Tradesmen".
Cheers,
Fernando