Slicer filter logic contains number

[jacobsutcliffe]

Hello, 

I have a dataset containing maintainance data for office buildings. Each line is a maintainance ticket containing details about the work required, time taken etc which is extracted from our system. However there is one field which relates to the room where the work is carried out which is causing me problems. 

Sometimes the maintainance required is carried out across multiple rooms (for example we had a water leak and it effected 2 rooms next to each other). The way the system outputs this data is in the same row, so the Room field would have an entry like R17, R18 (this happens quite often).

I'm currently trying to build a dashboard with this data with has a page where you can select the room using a slicer and it filters the visuals so that it shows all of the maintainance tickets against that specific room. 

This works fine using a page level filter with a contains logic. Is there anyway I could use a slicer for this along with some clever dax?

[v-easonf-msft]

Hi, @jacobsutcliffe 

The information you have provided is not making the problem clear to me.

If you share sample data and expected output in excel, it will help us provide the appropriate solution.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@jacobsutcliffe , Create a independet table, with room number and impacted room number , say imapct

room number , impacted room number

1,1

1 ,1

2 ,1

2,2

2,3

Now give slicer on room number and use that in filter of you measure

calculate( count(Table[Room]), filter(Table, Table[room] in allselected(impact[impacted room number] ))

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE