DAX How To Dynamically Concatenate Earlier Row Values

[Anonymous]

I would like to, using DAX because my table will be filtered dynamically and have different ModelNumbers each time, come up with a way to produce a concatenated list (comma deliminated) of all Val1 row values in scope.

ModelNumber	Val1	DYNAMIC COLUMN
100-01	456	456
200-01	21	456, 21
300-02	18	456, 21, 18
400-01	5	456, 21, 18, 5

CURRENT FORMULA:

            PreviousText = MINX(
                              FILTER('Table1',
                                       'Table1'[modelNumber] = EARLIER('Table1'[modelNumber])),
               'Table1'[Val1])

Current Result: Error Message: single value for modelNumber cannot be determined.

[LivioLanzo]

@Anonymous

Not sure if you are after something like this?

=
IF (
    HASONEVALUE ( 'Models'[ModelNumber] ),
    CONCATENATEX (
        FILTER (
            ALLSELECTED ( 'Models'[ModelNumber] ),
            'Models'[ModelNumber] <= SELECTEDVALUE ( 'Models'[ModelNumber] )
        ),
        CALCULATE ( SUM ( Data[Val1] ) ),
        ", "
    )
)

[Anonymous]

Thanks for the fast response. Your example is exactly what I am looking to do. My results outputs are not the same as yours. The only difference I see is all my data is coming from the same table, and you have the values coming from the data table as an example. What am I doing wrong?

See Concatenation is not working like yours

[LivioLanzo · Accepted solution]

@Anonymous

I just normalized the ModelNumber into a dimension table that is why you see it as another table

[Anonymous]

Thanks For Your Help! Working with the Formula and dim table suggestion.