Power BI Table visualization - issue with filtering with data from two different tables

[jerryr125]

Hi - I have a question about the table visualization.

Data Model

Data Model Table1

Location	Acounter
100	10
200	15
300	20

Data Model Table2

Location	Bcounter	Flag
100	125	Y
200	245	N
300	375	Y
400	450	Y

Power BI Table Visualization - Desired Result

Location	Acounter	Bcounter
100	10	125
200	15
300	20	375
400		450

If I add a Filter to the visualization above in which the "Flag" field = "Y", I still like to display the location "200" even though the Flag field = "N"  and the Acounter field has a value. 

RIght now it is not displaying the Acounter correctly since I added the filter to the table visualization in which the Flag field = "Y".

How can I accomplish this ? 

Thanks - Jerry

[lbendlin · Accepted solution]

Create a proper dimension table for Location. Add all four locations.

Create your data model.

  Then use that dimension column as the first column in the visual, and add the A and B values. Then apply the B filter.