Forum Discussion

jerryr125's avatar
jerryr125
Icon for Helper IV rankHelper IV
2 years ago
Solved

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

Hi - I have a question about the table visualization.

Data Model

 

Data Model Table1

LocationAcounter
10010
20015
30020

 

Data Model Table2

LocationBcounterFlag
100125Y
200245N
300375Y
400450Y

 

 

Power BI Table Visualization - Desired Result

LocationAcounterBcounter
10010125
20015 
30020375
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

 

 

 

 

Show and Tell
  • lbendlin's avatar
    lbendlin
    2 years ago

    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.

     

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    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.