topic Re: searching field and filtering out values that have all or part of the text. in DAX Commands and Tips

searching field and filtering out values that have all or part of the text.

RM117 — Mon, 29 Apr 2024 18:07:55 GMT

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!

Re: searching field and filtering out values that have all or part of the text.

tamerj1 — Mon, 29 Apr 2024 18:56:08 GMT

Hi RM117

please try

FilterMeasure =
COUNTROWS (
FILTER (
Data,
NOT ISEMPTY (
FILTER (
Systems,
CONTAINSSTRING ( Data[Element No.], Systems[Building Systems] )
)
)
)
)

Re: searching field and filtering out values that have all or part of the text.

Anonymous — Tue, 30 Apr 2024 05:58:36 GMT

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.