Filtering Data on Table 2 based on Include/Exclude Flag from Table 1 using Slicer

[Anonymous]

Hello Experts, 

I am facing the below issue. Please provide me a solution to fix this. 

I have two tables. 

Table 1 : 

Asset Group	Asset No	Include/Exclude Flag
AG1	A1	i
AG2	A1	e
AG3	A2	i
AG4	A3	i

Table 2:

Asset No	Value	Budget	Description
A1	1000	1200	asdf
A2	1200	1200	defg

I am creating a slicer on Table 1 - Asset group field. Now, based on the table 1 Include/Exclude flag , i should filter the values in table 2. 

For example, if i select 'AG2' in slicer , asset number 'A1' should be excluded as per the flag value 'e' and  asset numbers  'A2' and 'A3' should be displayed. Please help to acheive this. 

[VijayP]

@Anonymous 

Table 1 and Table2 are conected based on Asset Number , but Asset Group is not in both places hence , the logic is not getting build whether AG1  or AG2 is equal to "e", So you need to have Asset group in both the tables to achieve your result! Let me know if this is giving some idea

[parry2k]

@Anonymous your question is not clear, if you have filtered on "AG2" what is the business logic to see A2 and A3 since A2 and A3 don't even belong to AG2 asset group? Revisit your question and provide some more details.