Identify Returning/frequently Customers + Rank/Basket Analysis in last orders

[franorio]

Hello everybody,

In my Report I have done a Basket Analysis by duplicating my product table for a double filtering.

Also used RANKX formula to see the Top N products bought for each category (over 1000 products) 

I don't have a Client ID dataset, the only data I have from the client is the Email adress associated to the #salesorder from my fact table. 

How can I identify frequent or returning clients (by email, if the email appears more than once) to apply my rank & basket analysis just for the orders of clients who are buying frequently?

Trying to identify purchase trends, if client X buys frequently on the webpage, i would like to see.. if they bought product A, the first time, what are they buying on next orders, do they also bought Product A again, or which other products are they buying on their new orders. 

Thanks & regards!

[MFelix]

Hi @franorio,

Why don't you do a RANKX based on the count of the e-mail address something like:

Rank = RANKX(ALLSELECTED(Table1[Email]),CALCULATE(COUNTA(Table1[Email])))

This will give you something like this.

Regards,

MFelix

[spuder]

Hi,

could you post a "result table" you would like to have.

One thing that comes in my mind for your second part could be CONCATENATEX that would give you a list of all products bought behind the email address.