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

     

DimaMD's avatar
DimaMD
Solution Sage
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])

 

y5famfnatudu's avatar
y5famfnatudu
Resolver I
3 years ago

Hello DimaMD 
Were ALL the RFM fields R(Values), R(Score), F(Values), F(Score), M(Values), and M(Scores) created completely using just measures, or some were created using calculated columns?

Would appreciate it so much if you can share the pbix please with me, as I'm trying to find a way to do it all based just on measures, but unfortunately I found that all sources are using calculated tables and columns.

 

Best regards,

Simon