Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello, I have of list of transactions by customers like this:
I need to figure out the combinations of products by customer, something like this:
Also, I would like to be able to filter these product combos considering just customers who bought product "A" or product "A" and other.
Finally, I expect to have a visualization with this information:
Top product combos is the frequence in which a customer buys "A,B".
Thank you in advance 🙂
Solved! Go to Solution.
Hi, @danielgnic
You can try the following methods.
Column:
Product List =
CONCATENATEX (
CALCULATETABLE ( VALUES ( 'Table'[Product] ),
FILTER ( ALL ( 'Table' ),
[Transaction Type] = EARLIER ( 'Table'[Transaction Type] )
&& [Customer ID] = EARLIER ( 'Table'[Customer ID] ) ) ),
[Product],
","
)
Measure:
FREQENCE = CALCULATE(DISTINCTCOUNT('Table'[Customer ID]))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-zhangti , thank you for your reply.
Your formula did work, however, I have something like this:
I would like to be able to filter by transaction type and also by date:
This example shows just transactions that are "REGISTER". I'd like to the the same but with dates (for example, I'd like to see just data between march 10th and march 12th).
Finally, I'd like to get the frequence that I have per list or product combo, for example:
Consider as well than I'm trying to filter from the beginning customers that bought product "A" and some other product.
Thank you in advance 🙂
Hi, @danielgnic
You can try the following methods.
Column:
Product List =
CONCATENATEX (
CALCULATETABLE ( VALUES ( 'Table'[Product] ),
FILTER ( ALL ( 'Table' ),
[Transaction Type] = EARLIER ( 'Table'[Transaction Type] )
&& [Customer ID] = EARLIER ( 'Table'[Customer ID] ) ) ),
[Product],
","
)
Measure:
FREQENCE = CALCULATE(DISTINCTCOUNT('Table'[Customer ID]))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @danielgnic
You can try the following methods.
New Table =
SUMMARIZE ( 'Table','Table'[Customer ID],
"Product Combo", CONCATENATEX ( VALUES ( 'Table'[Product] ), [Product], "," )
)
Can you provide more sample data to explain the logic of the last graph?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
107 | |
89 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |