Filter Dimension Two by column in Dimension One

---

cturner wrote:

 

This is helpful, and may contain the seeds of a working approach.  However, I don't want to use ID for the condition.  I want to use type:

 

Table 1

 

id,business name,type

1,bname1,type1

2,bname2,type2

3,bname3,type1

4,bname4,type2

 

Table 2

 

id,productname,type

1,pname1,type1

2,pname2,type2

3,pname3,type1

4,pname4,type2

 

Slicer1 for type in table 1 contains the values type1,type 2.

Slicer2 for productname in table 2 contains the values pname1-pname4.

 

I want the type selected in slicer 1 to determine the contents of slicer 2

 

type 1 ->  pname1,pname3

type 2 -> pname2,pname4

 

Thanks.

---

cturner

Then create a measure in the same way with type column.

isExistsInTable1 = IF(LASTNONBLANK(Table2[type],"") in VALUES(Table1[type]),1,BLANK())