How to measure unique Leads?

[Skype]

Hey there,

I have the following case. Customers with a certain budget request several different products from us for comparison.
Usually those request spread for a period of 5 days. However, of all that quotes the customer will usually only buy 1 product.


What I now want to do in PowerPivot is to count the unique request. So if a customer requests 10 items during a period of 5 days this is not counted as 10 requests but only as 1. However, if couple of days later he requests further products it is again counted as one request.

I was thinking about filtering as follows:

Unique requests:=CALCULATE(DISTINCTCOUNT(CUSTOMER ID); xxxx)

I think one solution might be: =CALCULATE(DISTINCTCOUNT(CUSTOMER ID); DISTINCTCOUNT(WEEK NR)) - I am not quite sure if that works, though. Plus I will count them twice if they happen to continue their request on the next week but still within a period of 5 days.

What do you guys think about this?

 

[Ozeroth]

Have a look at this page on DAX Patterns
New and Returning Customers – Dax Patterns

One of the Recovered Customers measures is similar to what you are wanting to do. You may need to modify based on your definition of a block of requests. If the interval between blocks of requests is important, then the DAX Patterns version should work more-or-less as is. If the length of the block of requests is important (eg the five days you mentioned) then some changes would be needed.

How would you treat 10 consecutive days of requests from a customer, if it could happen?

 

[Skype]

Have a look at this page on DAX Patterns
New and Returning Customers – Dax Patterns

One of the Recovered Customers measures is similar to what you are wanting to do. You may need to modify based on your definition of a block of requests. If the interval between blocks of requests is important, then the DAX Patterns version should work more-or-less as is. If the length of the block of requests is important (eg the five days you mentioned) then some changes would be needed.

How would you treat 10 consecutive days of requests from a customer, if it could happen?

Wow thanks I lot. Though, I think it will take me some time to really understand it.