Use a slicer to filter a table based on a measure output

[Anonymous]

Hi,

I have a matrix table that has a row of locations and a measure that has 3 different outputs. I want to use a slicer to filter the table based on these 3 measure outputs. 

So in the example below, if I select type 3 then it filter my table to only show type 3.

Slicer:

Type1, Type2, Type3

Matrix Table: 
OWS 

ROWS	Measure
London	Type 1
Manchester	Type 1
Newcastle	Type 2
Leeds	Type 3
Glasgow	Type 1

So far I have created a table with the 3 measure types and added this field to a slicer, I have then attempted to create a measure with something roughly like this; 
IF(contains(SlicerTable, SlicerField, "Type1"),measure = "Type1","Type2")

However it doesn't work and I can't think how best to adjust it?

Any ideas?

[Greg_Deckler · Accepted solution]

@Anonymous You will need to use the disconnected table trick. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563