Need Slicer to filter other columns based on selection

[MeggieD00dles]

 Greetings all! I have two very large datasets (4000+ rows, 150+ columns each) for services requested and services provided by request ID. In the Service Provided dataset, I have a series of columns where it is indicated which specific services were provided, where 1 indicates the service was provided and a 0 indicates the service was not provided (multiple services can be provided for the same request ID)

Any BERD Services	Any CES Services	Any CTA Services	Any HUB Services
0	1	0	1
1	0	0	0
0	0	1	1

I am trying to find out the best way to create a slicer visual with the following categories: "BERD Services", "CES Services", "CTA Services", and "HUB Services", and when any of those categories are selected, I need all of the visuals on that page to filter by services provided (1) in the proper "Any _ Services" column. 
I am somewhat new to Power BI and DAX, but I am willing to learn! Any help is appreciated.

[Chris_White]

Try creating this calculated column (don't try it as a measure, it won't work):

MyColumn = if([Any BERD Services]=1 || [Any CES Services]=1 || [Any CTA Services]=1 || [Any HUB Services]=1,1,0)

You can call it something more meaningful than "MyColumn" I'm sure. The "||" is an "or", you can use "&&" if you ever need an "and".

Anyway, use this new column in your slicer and it will filter to the ones you want.