Concatenate all LOOKUPVALUE matches using a calculated column?

[olimilo]

We have the following datasets: Table1 would contain all the data regardless of RESULT while Table2 will contain all the failures:

Table1
ID		RESULT
1		FAIL
2		PASS
3		FAIL
4		PASS
5		PASS

Table 2
ID		CRITERIA
1		Color
1		Size
3		Size
3		Packaging
3		Adhesive

Would it be possible to concatenate all CRITERIA values from Table2 with matching IDs from Table1 as a calculated column? I understand this can be done via query but preferably we'd like to do this via DAX to reduce query refresh duration.

Desired output
ID		RESULT		FAILED_CRITERIA
1		FAIL		Color, Size
2		PASS
3		FAIL		Size, Packaging, Adhesive
4		PASS
5		PASS

[olimilo · Accepted solution]

Was able to find a solution through here: https://community.fabric.microsoft.com/t5/Desktop/Concatenatex-Lookupvalue-multiple-values/m-p/73929...

In my case, the tables are not related to this works:

FAILED_CRITERIA =
CONCATENATEX (
    CALCULATETABLE (
        VALUES ( Table2[CRITERIA] ),
        Table2[ID] = EARLIER ( Table1[ID] )
    ),
    Table2[CRITERIA],
    ", "
)