Forum Discussion
RFM classification help
Hi, I am trying to do a RFM segmentation example for the marketing team. I am able to do the segmentation using measures. Please see the sample file here. My requirements: 1. Need to be abl...
I think the best technique would be to "Split by delimiter" in Power QUery mode and get RFM Classification from cstRFMClassification field
and next there are 2 option:
1. simple scenario - just add Classification in visual and the second field "Classification" aggregated by Count (visual settings in visualization pane)
2. SUMMARIZE('Table';[RFM Classification];"Count";Count([RFM Classification]))
do not hesitate to give a kudo to useful posts and mark solutions as solution