Forum Discussion
Solved
Customer Segmentation
Hi everyone, I would like to calculate Q1. how many user been visit the store for {2-4 times, 5-7 times, 8 times and above}; Q2. how many user been spend for {RM100 and below, RM101-RM300, RM3...
Hi,
Please check the below picture and the attached pbix file.
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
I hope the below can provide some ideas on how to create a solution for your datamodel.
All measures are in the attached pbix file.
