Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 CompanyCategory is "Tradesman". If I run a query in SQL Server or when I look in my data in the Data tab I see the Tradesman values in the table. Seems simple. So I have a DAX formula like this:
Solved! Go to Solution.
Hi @Anonymous ,
You have a typo in your measure my friend!
You wrote "Tradesman", it should be "Tradesmen".
Cheers,
Fernando
Hi @Anonymous ,
Why don't you share your pbix file to understand your data?
Regards,
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.
Hi @Anonymous ,
No worries, this forum is to help users in the community.
Just mark the question answered if you agree.
Regards,
Fernando
Hi @Anonymous ,
You have a typo in your measure my friend!
You wrote "Tradesman", it should be "Tradesmen".
Cheers,
Fernando
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |