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.
Hey all,
So I have two tables:
Table01, which countain a list of Assets, with one column being a list of Groups it belongs to - Comma seperated.
Table02, which was generated as a seperate table to contain all of these independent Group names, de-duplicated and cleaned.
I would like to add another column within Table02 to show many Assets within Table01 are part of this specific group, but I can't seem to find something that works across tables (no relation) utlising Contains.
A brief view...
Table01:
Asset Name | Groups
Asset01 | Group01, Group03
Asset02 | Group02
Asset03 | Group02, Group03
Table02:
Group Name | Number of Assets
Group01 | ?
Group02 | ?
Group03 | ?
Any help would be very much appreciated!
Thanks in advance.
Solved! Go to Solution.
@JSaunders , new column in table 2
countx(filter(Table1, containsstring(Table1[Group], Table2[Group])), Table1[Assets])
or
calculate(distinctCOUNT(Table1[Assets]) , filter(Table1, containsstring(Table1[Group], Table2[Group])))
@JSaunders , new column in table 2
countx(filter(Table1, containsstring(Table1[Group], Table2[Group])), Table1[Assets])
or
calculate(distinctCOUNT(Table1[Assets]) , filter(Table1, containsstring(Table1[Group], Table2[Group])))
Perfect! the CountX option worked like a dream.
Thanks for the help.
User | Count |
---|---|
90 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
147 | |
113 | |
95 | |
81 | |
71 |