The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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])
Hi Jihwan:
I'm sorry if I answered after you. I did not see any answer yet when I answered. Thank you..
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |