Sum of an individual distinct count

[Kaskazi_Network]

Hi everyone,
I have some data as represented in the dummy table below;

sales rep	sku	Qty	price	Date
James	sku1	3	20	7/28/2021
James	sku1	2	20	7/29/2021
Peter	sku2	5	15	7/30/2021
Peter	sku1	4	20	7/30/2021
Ken	sku3	3	30	8/1/2021
Ken	sku2	5	15	8/2/2021
Ken	sku2	3	15	8/3/2021

My goal is to calculate the sum of  days worked for the three sales reps i.e James worked for 2 days, Peter worked for 1 and Ken worked for 3 days. So my total days worked would be 6. Getting for an individual is easy as I just do a distinct count of date. The question is how do I get the sum for the whole team?

Any help will be highly appreciated 

[v-easonf-msft]

Hi,  @Kaskazi_Network 

Could you please tell me whether your problem has been solved?

If yes, you could accept the helpful answer as solution. You could also share your own solution here.
For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[Kaskazi_Network]

I have not found a solution as yet. Here's how my data looks like;

Full names represents the sales reps. They are multiple working on the same day but not all work on a particular day. Kindly advise if you need more details on this..

Thanks

[v-easonf-msft · Accepted solution]

Hi, @Kaskazi_Network 

You may try formula as below:

Measure = COUNTROWS(SUMMARIZE('Table','Table'[Date],'Table'[full_name]))

Best Regards,
Community Support Team _ Eason

[Kaskazi_Network]

@v-easonf-msft This solved exact my problem. Thank you!

[Ashish_Mathur]

Hi,

The Distinctcount() function should work even for the entire team.  The result of that formula should be 6.

=distinctcount(data[date])

[thedatahiker]

@Kaskazi_Network 
Right now each of the examples you share is on different days.

You can calculate the total days worked for the team by using a formula like this

CALCULATE (

DISTINCTCOUNT ( Table[Date] ),
ALL ( Table )
)

It will get more complicated if you have 2 Sales Reps who work on the same day.

[Kaskazi_Network]

Thank you for your response.
The formula however does not work for my dataset as I have multiple sales reps working on the same day.