Avg. visit plan per day

[ADSL]

Hi BI Community Team,

I have a table of "Visit Plan" that it's preparing by sales rep and submit to us every month.

Follow the working day of the month (e.g. no. working day in July have 26 day), we want to know the avg. visit plan per day by sale rep, sales team.

Logic_SR = total no. of visit plan / total no. working day

Logic_Team = total no. of visit plan / total. no of sales rep belong to team / total no. working day

Any suggestion/advise?

Thanks and Regards,

[Ashish_Mathur]

Hi,

Based on the sample table that you have shared, show the expected result very clearly.

[ADSL]

Hi @Ashish_Mathur ,

Thank you for your feedback. 

May I need your support of this post? the screenshot below, it's the expect result and calculation.

Avg. visit per day should be divide by no. working day when we choose the "Month" slicer. for team, Avg. visit per day should be no. visit plan / total sales rep of team / no. working day.

Thanks and Regards,

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[ADSL]

Hi @Ashish_Mathur ,

Here is the link of file - https://drive.google.com/drive/folders/11WhohpJrJSWio_WNbesqlQCMjaTn1spq?usp=sharing 

Thanks and Regards,

[Ashish_Mathur]

Hi,

Just simplify the measure to:

Working Days (Month) = CALCULATE(COUNTROWS('Calendar'),'Calendar'[DayInWeek]<=5)

and everything falls in place.

Hope this helps.

[ADSL]

Hi @Ashish_Mathur,

Thank you for helpful feedback.

Sorry... May I need your help of Avg. visit plan by team? That's calcaluation is: 

Visit plan / No. of sales rep / Working Day

Thanks and Regards,

[Ashish_Mathur · Accepted solution]

Hi,

Write this measure.  File attached.

Avg. Visit per team = DIVIDE(DIVIDE([Visit Plan],[Working Days (Month)]),DISTINCTCOUNT('Visit Plan'[SALESREP_CODE]))

[ADSL]

Hi @Ashish_Mathur ,

Thank you very much for your helpful feedback and advise.

Best Regards,

[Ashish_Mathur]

You are welcome.