Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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.

 

 

 

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi amitchandak, 

       

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