Using DISTINCTCOUNT to find distinct names in table

[sjade]

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? 

[Whitewater100 · Accepted solution]

Hi:

If your table name = Team  then

DC Team =

var teamname = SELECTEDVALUE(Team[Team])

return

CALCULATE(DISTINCTCOUNT(Team[name]), FILTER(ALL(Team),

Team[team] = teamname))

[Whitewater100 · Accepted solution]

Hi:

If your table name = Team  then

DC Team =

var teamname = SELECTEDVALUE(Team[Team])

return

CALCULATE(DISTINCTCOUNT(Team[name]), FILTER(ALL(Team),

Team[team] = teamname))

[sjade]

This is what I am looking for. is there anyway to add this value to the source table as a column? 

[Whitewater100 · Accepted solution]

Hi:

Yes:

Dist CT =

CALCULATE(

DISTINCTCOUNT(Team[name]),

FILTER(ALL(Team),Team[Team] = EARLIER(Team[Team])))

[sjade]

Thank you so much! 

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

Employee count in each team: = 
DISTINCTCOUNT(Data[name])

[Whitewater100]

Hi Jihwan:

I'm sorry if I answered after you. I did not see any answer yet when I answered. Thank you..