Product Pathways

Hi SammyNed ,

I have created a simple sample, please refer to it to see if it helps you.

Create a column.

rankx = RANKX(FILTER('Table','Table'[Cst]=EARLIER('Table'[Cst])),'Table'[Date],,ASC,Dense)

Then create a measure.

Kettle =
VAR _1 =
    CONTAINSSTRINGEXACT (
        CONCATENATEX ( ALLSELECTED ( 'Table' ), 'Table'[Product], "" ),
        "Kettle"
    )
        = TRUE ()
VAR _1first =
    CALCULATE (
        MAX ( 'Table'[Product] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Cst] = SELECTEDVALUE ( 'Table'[Cst] )
                && 'Table'[rankx] = 1
        )
    )
VAR _2first =
    CALCULATE (
        MAX ( 'Table'[Product] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Cst] = SELECTEDVALUE ( 'Table'[Cst] )
                && 'Table'[rankx] = 2
        )
    )
VAR _3first =
    CALCULATE (
        MAX ( 'Table'[Product] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Cst] = SELECTEDVALUE ( 'Table'[Cst] )
                && 'Table'[rankx] = 3
        )
    )
RETURN
    _1first & "   " & _2first & "   " & _3first

If I have misunderstood your meaning, please provide more details with your desired output.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.