Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Solved! Go to 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],
", "
)
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],
", "
)
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |