Forum Discussion

DimaMD's avatar
DimaMD
Solution 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,

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
Solution Sage
4 years ago

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