Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi,
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |