Apply filter to disconnected tables

[Kayla2020]

Hi,

I have a matrix table based on dept and cost.  There are two disconnected tables(based on project) used in the matrix to return dept costs for selected projects. I want to create a slicer for country and cluster to filter the disconnected tables i.e if a country and cluster are selected, the disconnected table returns projects available in the selected country and cluster. 

Please how do I achieve this? Also, find attached the file.

Thank you.

project	dept	cluster	country	cost
Project A	HR	1	France	5700
Project b	Logistics	1	Poland	7487
Project c	Product design	2	France	7207
Project d	Transport	1	Turkey	7374
Project e	HR	1	UK	13018
Project f	Logistics	2	Poland	10117
Project g	Product design	2	Turkey	6348
Project g	Transport	2	France	8902
Project h	HR	1	Poland	6061
Project j	Logistics	2	France	10677
Project i	Product design	3	Turkey	6952
Project k	Transport	3	UK	7970
Project f	HR	1	Poland	10940
Project n	Logistics	2	Turkey	6979
Project m	Product design	1	Turkey	11587

[v-shex-msft]

HI @Kayla2020,

You can add variable to use values function to extract the filter effect from the target table and manually use this in your calculations expressions to apply filter effect from disconnected table.

Regards,

Xiaoxin Sheng

[ThxAlot · Accepted solution]

Based on your description, TREATAS() would come into play.