Help to group specific customers on frequency of their transactions

AREO-07 — Wed, 28 Oct 2020 09:46:10 GMT

Hi,

Need help in creating a dax measure to count number of frequency of loyal customers.

Please see my table below.

and i am using these dax measure to identify which customer have transactions every month

Loyal Unique Users = VAR VisibleMonths =

CALCULATE(

DISTINCTCOUNT('Append1'[Report Date]),ALLSELECTED('Append1'))

VAR UserWithTxnEachMonth =

SUMX(VALUES(Append1[Loyalty Card Number]),

VAR HasatLeast1TxnEachMonth =

CALCULATE(

COUNTROWS(SUMMARIZE('Append1',Append1[Report Date])) = VisibleMonths, ALLSELECTED('Calendar'))

Return IF(HasatLeast1TxnEachMonth,1))

Return UserWithTxnEachMonth

The dax measure helps me identify the loyal customers. Now i need to use this as filter and identify the loyal customers and

group them and count which of them have transacted once, twice and so on using the by using the frequency column as x axis in a visual.

I tried using this dax measure:

SUMX(VALUES(Append1[Loyalty Card Number]),CALCULATE(COUNTROWS(SUMMARIZE(Append1,Append1[Report Date])),FILTER(Append1,HasatLeast1TxnEachMonth=TRUE()),ALLSELECTED('Calendar')))

but the result is blank

Really need help in solving this problem.

Thank you

Re: Help to group specific customers on frequency of their transactions

amitchandak — Wed, 28 Oct 2020 11:03:18 GMT

AREO-07 , if you need to group based in Meausre then you need binning or segementation using an independent table

refer: https://www.youtube.com/watch?v=CuczXPj0N-k

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

topic Re: Help to group specific customers on frequency of their transactions in DAX Commands and Tips

Help to group specific customers on frequency of their transactions

Re: Help to group specific customers on frequency of their transactions