Forum Discussion
converting measures to dimension?
Hi,
PBI file attached.
Hope this helps.
Super Userwhat's the expected output based on the sample data you provided?
hey Ryan! thanks for following up.
This is the expected output:
Thank you.
- ryan_mayu
what's the calculation logic? how many member only buy one brand? how many buy two?
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.
- Ashish_Mathur
Hi,
PBI file attached.
Hope this helps.
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.
- Ashish_Mathur
You are welcome. I am not aware of an alternative.