DAX count days that sales made calls

[beckyb822]

I need to determine how many business days a sales person worked in a given month.  Basically need to count the days where they made more than one call.  Any ideas on what that DAX might look like?  

[Anonymous]

You could create a table like this:
SUMMARIZCOLUMNS("EmpID" [EmpID], "Calls", "Year", YEAR([call Date], "Month", MONTH([call date]), COUNT(call Date) 

[beckyb822]

My data is call records, so I first need to group/filter by rep.  Then count how many per day.  Then count how many days in a month the count was > 0.  

EmpID	Call Number	Call Date
1	123456	2/1/2023
1	89821	2/2/2023
2	36892	2/10/2023
3	63987	3/1/2023
3	45623	3/20/2023

[Anonymous · Accepted solution]

Hi @beckyb822 ,

The possible solution is use DISTINCTCOUNT function.

Solution1 = DISTINCTCOUNT('Table'[Call Date])

Or use

Solution2 = CALCULATE(DISTINCTCOUNT('Table'[Call Date]),FILTER(ALLSELECTED('Table'),[EmpID]=MAX('Table'[EmpID])))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Anonymous]

Can you provide an example small table (anonymised data).