Hi,

We've try to measure benefit by customer, so is a ratio, the numerator is the benefit per month and the denominator is the number of the customer at the end of the month.

01/2013 02/2013 ... 12/2013

500/100 450/110 ... 550/105

The problem comes when users try to see the benefit by customer for the year. The measure will add the benefit of each month but ALSO ALL THE NUMBER OF CUSTOMER, but the number of customer has to be the most recent or an average.

How can we param the measure to be a SUM at the numerator and a AVG at the denominator ?


Thanks you,

One possible solution would be to provide a month counter that you can use to do the average calculation on the denominator. The month counter is the count of the number of distinct months.

For example:

SUM(Benefit) / ( SUM(NumCustomers) / MonthCount )

I thing, that you can not do this in PMF. PMF expect a numerator and a denominator, not a formula.