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.
Good afternnon all. I have a table taht has a list of building systems;
Building Systems | Description |
A | SUBSTRUCTURE |
A10 | Foundations |
A20 | Slab-on-Grade |
B | SHELL |
B10 | Superstructure |
B20 | Exterior Enclosures |
B30 | Roofing |
C | INTERIORS |
The Data looks something like this;
Op Center | Element No. | Building # | Work Description |
8650 | A1010 | 4 | Repair damage precast foundation |
8650 | A1010 | 4 | Install joint sealant in precast foundation joints |
8650 | A1010 | E | Provide adequate foundation |
8650 | A1010 | Hot Stick | Provide adequate foundation |
8650 | A1020 | 2 | Replace Joint Sealant in floor control joints |
8650 | B1010 | E | Install new concrete slab |
8650 | B2010 | 1 | Clean and repoint brick mortar joint |
8650 | B2010 | 1 | Replace siding between windows |
What I'm trying to do, is create a slicer with Building Systems as drop downs. So if I select B10 or preferably SHELL, I will get all B10's including B1010, B1020, B1030 and so on.
Any help wouold be greatly appreciated 🙂
Thanks!
Solved! Go to Solution.
Hi @RM117 ,
I think you can use Groups.
Then you can get what you want.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RM117 ,
I think you can use Groups.
Then you can get what you want.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RM117
please try
FilterMeasure =
COUNTROWS (
FILTER (
Data,
NOT ISEMPTY (
FILTER (
Systems,
CONTAINSSTRING ( Data[Element No.], Systems[Building Systems] )
)
)
)
)
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
119 | |
41 | |
40 | |
28 | |
22 |