Forum Discussion
How to purchasing frequency
Hi team, Please help me on this point. I have sale record with difference customer. I want to count the customer that purchase for 2 time, 3 times, 4 times, .....
CheanSereyvatan , You have use dynamic segmentation
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
cnt = Count(Table[Customer ID]) is the measure you have used
bucket = Generateseries(1, 100) will help you create a new table for group by/filter
and measure like
countx(filter(Values(Table[Customer ID]),[cnt] = max(Bucket[Value]) ), [Customer ID] )
or
sumx(bucket, calculate(
countx(filter(Values(Table[Customer ID]),[cnt] = max(Bucket[Value]) ), [Customer ID] ) ))
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k