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])

     

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?