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.
I have a table with the following setup:
Team | name | skill | rating |
database | john smith | SQL server | 3 |
database | john smith | DAX | 3 |
database | jimmy plank | SQL Server | 2 |
engineering | susie q | ETL | 2 |
engineering | susie q | SQL | 3 |
engineering | issac walker | ETL | 1 |
There are about 50 skills per person. And there are a varying number of people on each team. I am trying to write a DAX measure to count the distinct amount of employees on each team. Any suggestions?
Solved! Go to Solution.
Hi:
If your table name = Team then
Hi:
Yes:
Hi:
If your table name = Team then
This is what I am looking for. is there anyway to add this value to the source table as a column?
Hi:
Yes:
Thank you so much!
Hi,
Please check the below picture and the attached pbix file.
Employee count in each team: =
DISTINCTCOUNT(Data[name])
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi Jihwan:
I'm sorry if I answered after you. I did not see any answer yet when I answered. Thank you..
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |