Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Members,
I have a report with a transaction listings of members across different brands.
The data is organized similar to the below table:
The end goal required, is to undertand what percentage of members spend in 1,2,3, etc brands:
I cant seem to figure a way out on power bi.
would appreciate your kind input and suggestion.
Thank you!
Solved! Go to Solution.
Hi,
PBI file attached.
Hope this helps.
what's the expected output based on the sample data you provided?
Proud to be a Super User!
hey Ryan! thanks for following up.
This is the expected output:
Thank you.
Hello Ashish,
Thank you so much for your help.
This solution works. However, as my database is large, I noted that it takes a long time to generate the visual.
What other alternatives would you suggest?
Thank you, Ashish.
You are welcome. I am not aware of an alternative.
what's the calculation logic? how many member only buy one brand? how many buy two?
Proud to be a Super User!
Hey Ryan,
Thanks for following up.
Essentially, what I am trying to understand is that from the total memberbase, what percentage of our members only purchase from 1 brand, 2 brands, 3 brands, etc.
Thank you.
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |