Creating Dynamic table visual based on another table visual

[Anonymous]

Hi Team,

I have three tables in Power BI (Country, State and Category) and based on these three tables, I have three slicers in my power bi report  and two table visuals. I have two table visuals also in my report. My first visual has column Country Name, State Name and Category Name and my second visual has column Country Name and State Name. My first visual should display data based on the slicer selection but my second table visual should contain only the combination which is not available in first visual. Suppose the tables has the below data

Country Table			State Table					Category Table
Country ID	Country Name		Country ID	State ID	State Name		CountryID	StateID	CategoryID
C1	Country1		C1	S1	State1		C1	S1	Cat1
C2	Country2		C1	S2	State2		C1	S1	Cat2
			C2	S3	State3		C1	S1	Cat3
							C1	S2	Cat1
							C1	S2	Cat4
							C2	S3	Cat4

In this if Slicer for Country selects All and State selects all But Category selects only Cat1, Cat2 and Cat3. In this case first table visual should have values

Country Name	State Name	Category Name
Country1	State1	Cat1
Country1	State1	Cat2
Country1	State1	Cat3
Country1	State2	Cat1

Then the second table visual should have only 1 row which is Country2 and State2 since that combination is not present in first table. Suppose if the slicer has only values Cat1 selected, then the first table visual has only 2 rows which is Country 1 and State1 and Country1 and State2. In this case also second table visual has only one row, which is Country2 and STate2. So 3rd slicer should not affect second table visual. It should contain all combinations which is not present in first table visual. But first and second slicer should affect both table visuals 

[tamerj1]

Hi @Anonymous 
This is possible only using start schema data model plus some modifications. A factTable need to be introduced having the Country Name and State Name columns (that will be used in the 2nd table). Please refer to attached sample file for more details.

FilterMeasure = INT (  ISEMPTY ( FactTable ) )

[Anonymous]

Thanks for the reply. But In this solution, I need the filter criteria of Country and State to be applied in both visuals. If Country 1 is not selected, then it should not be present in two visuals. 

[tamerj1]

@Anonymous 
Not sure if I fully understand. However, please check new proposed solution as per attached sample file.

FilterMeasure = INT (  ISEMPTY ( Category ) && NOT ISEMPTY ( State ) )