How to purchasing frequency

[CheanSereyvatan]

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, .....

[amitchandak]

@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/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k