- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Using DISTINCTCOUNT to find distinct names in table
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi:
If your table name = Team then
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi:
Yes:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi:
If your table name = Team then
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is what I am looking for. is there anyway to add this value to the source table as a column?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi:
Yes:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jihwan:
I'm sorry if I answered after you. I did not see any answer yet when I answered. Thank you..

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-19-2024 08:35 PM | |||
08-04-2022 09:27 AM | |||
08-20-2024 07:43 AM | |||
03-05-2024 08:54 AM | |||
02-22-2024 01:56 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |