Calculating Actions per Business Day for each Month

[CSMcVey]

I have a PowerPivot workbook with 2 data sets:

1st Data Set - contains metric information per day (Date / Metric / Count / ClientID)

12/1/12 - Open Orders - 5 - Client123
12/1/12 - Open Orders - 4 - Client456
12/2/12 - Closed Orders - 10 - Client543

2nd Data Set - contains various date attributes for each specific date

This data set contains an attribute called business day of the month. For example 12/1, 12/2 & 12/3 would all have a value of 1.


What I need to do in Pivot Tables / Graphs is compute a metrics per business day for each month. For example for Client123 the Open Orders per Business Day for November would be equal to the sum of the count for Open Order items divided by the number of business days in November. The value for December would be the sum of Open Orders divided by the number of business days up to that point

Any ideas on how to get this started? I've hit a wall

Note I am using Version 10.50.4000.0 - restricted to this due to SharePoint, don't have the Distinct Count function

 

[Laurent C]

With V1, counting the distinct values can be done this way:
[Nr Of Distinct Business Days]
:=COUNTROWS(
DISTINCT(Calendar[Business Day Of Month])
)
[Sum Of Metric Count]
:=SUM(Data[Count])
This measure should give the required result:
[Sum Of Metric Count]/[Nr Of Distinct Business Days]

 

[Laurent C]

The number of business days "up to that point" (which I translated "as up to now") can be obtained this way:
<pre>
=CALCULATE(Data[Nr Of Distinct Business Days];
FILTER(Calendar;
Calendar[Date] <=NOW()
)

)
</pre>