How to dynamically aggregate member purchase frequency

[Anonymous]

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.

[amitchandak · Accepted solution]

@Anonymous , I think you need Dynamic segmentation 

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

[Anonymous]

Hi amitchandak, 

Thank you so much! I watched this video and this is excatly what I want!