Displaying points selected using AND logic on the map

[Mila22]

Hi,

I'd like to ask for your help.

I have connected the data from the excel table "Table". The table contains information about randomly selected petrol stations -> GPS location of the petrol station, distance in km, name of the road and a column with information about services available -> toilets, shop, restaurant, gasoline sales. Each service is on a separate row for each petrol station.

I then created a slicer "Services".

I would like to use it to "filtering" the petrol stations by using AND logic. That's why I added Measure to the Table, which applies AND logic.

The data is selected using Measure and listed correctly in the table below the map. However, the map does not respond to the selection, all points are still displayed. 
Here I would need advice on how to link it? Add another table to link the selection and the map? Or modify the relation?

Thank you for your hepl!

Mila

[Mila22]

Hi,
first of all I will state that I am starting with PowerBI, so there are definitely better solutions than mine.
What I want to achieve is to select data with AND logic instead of OR logic that slicer normally uses.

To give an example, I want to show all points in the map that have, for example, a restaurant AND also a store. I don't care about points that have only restaurant or only shop, both conditions of the shop + restaurant selection must be met.

Thanks!

[TomasAndersson]

Hi!
Just so I understand better. Why do you want to filter using a DAX expression instead of a "regular" slicer? Wouldn't it be easier to just create a slicer based on Table[Services], alternatively create a relatioship between Table[Services] and Services[Services] and a slicer based on Services[Services]? 

Maybe there is a specific reason I don't understand.