RFM Model - How to create a Cluster Record to visualize evolutiong throught time?

Hi Anonymous ,

I created the following measures:

Last Order Date = MAX(Orders[created_at])

Days Without Order Number = DATEDIFF([Last Order Date];MAX(DimDate[Date]);DAY)

Recency Note value = 
SWITCH (
    TRUE ();
    [Days Without Order Number] < 7
        && [Last Order Date] <> BLANK (); 5;
    [Days Without Order Number] >= 7
        && [Days Without Order Number] < 14; 4;
    [Days Without Order Number] >= 14
        && [Days Without Order Number] < 30; 3;
    [Days Without Order Number] >= 30
        && [Days Without Order Number] < 60; 2;
    [Days Without Order Number] >= 60
        && [Days Without Order Number] < 90; 1;
    0
)

Also created a dimension table with dates and another one with the clusters:

IDCluster

Now add the following measure:

Cluster_Count =
VAR temptable =
    SUMMARIZE ( Clients; Clients[id]; "Recency"; [Recency Note value] )
RETURN
    IF (
        MAX ( DimDate[Date] ) <= MIN ( Orders[created_at] );
        BLANK ();
        CALCULATE (
            COUNTROWS ( FILTER ( temptable; [Recency] IN VALUES ( 'Cluster'[ID] ) ) )
        )
    )

See result below:

The two slicers on the bottom are for the order dates and for the date dimension  table that will allow to have filters. these two slicers are sincronized with each other.

Check file attach, and if you need any further assistance please tell me.