Forum Discussion
How to dynamically aggregate member purchase frequency
Hi, I am quite new to DAX, and I want to aggregate member purchase frequency dynamically.
So I have a dataset which looks like this:
Now, I have a basic level aggregation for purchase frequency, which is dynamic to the "date" and "rule" filters, like below:
But I want to aggregate this further, to only "Frequency" and "Member count", like this:
Do you know how I can achieve the last one, while still keep it dynamic to the "date" and "rule" filters? Any suggestions would be highly appreciated.
Anonymous , I think you need Dynamic segmentation
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
2 Replies
- amitchandakSuper User
Anonymous , I think you need Dynamic segmentation
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
- AnonymousNot applicable
Hi amitchandak,
Thank you so much! I watched this video and this is excatly what I want!