Forum Discussion

DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
4 years ago
Solved

RFM segments

Hello community!   I've made RFM analysis in table. Score of RFM is calculated in real time with mesure.   I have another table with scores and names of segments. so every combined RFM score has ...
@dax @help
  • DimaMD's avatar
    DimaMD
    4 years ago

    HI, HotChilli 
    thanks for the tip, yesterday I managed to figure it out myself and write such a measure.
    I think someone will find this measure useful

     

    Segment RFM = 
VAR _tab = 
SELECTCOLUMNS(
    VALUES('Sales'[ID_USER]),
    "RFM_Seg",[RFM] )
VAR _Seg =
SELECTCOLUMNS(_tab,
    "#RFM_S",
    LOOKUPVALUE('Segment'[Segment],Segment[ID_RFM],[RFM_Seg]))
return
MAXX( _Seg,[#RFM_S])

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Dima,

 

I am had the same issue. But I am wondering if you can share how you segments table looks like. I am still having issues even after connecting segments tbale with my RFm scores. Thank you! 

 

Best,

 

Nura 

  • DimaMD's avatar
    DimaMD
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi Anonymous  save the file, I think you will see everything there
    example file pbix

    greetings from Ukraine

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Dima,

      Thank you very much for sending the above file. It was very useful, however I am still getting the same error that you had. Also, after reviewing your file I realised that you have the same segment name for 

      each RFM score. Did you happen to fix that? Thank you! 

       RFM

      • DimaMD's avatar
        DimaMD
        Icon for Solution Sage rankSolution Sage
        4 years ago

        Hi Anonymous , Can you provide a sample of your data?