How to use a slicer from one table to filter records in another table

[Anonymous]

Hello the community! - I am new to Power BI and stuck in the following situtation for quite some days.   The following screen shot shows two tables Allocation and Obligation.  I want to use one slicer (EventFY) from Allocation table to filter records in Obligation. The two tables are linked by ERCode.  But we cannot join them together, as join will cause duplicate records.

What I want to reach is to sum obligations by State as shown in the bottom.  When 1990 is selected, the Obligations should show 600 and 1300 for A and B, respectively, and  900, 800 when 1991 is selected. 

You can get the data and report from the following links.  Any help is greatly appreciated.

(excel) https://1drv.ms/x/s!AlntzgQcvbvR2D0cnh_VTTAaN2Qd?e=Tsa89V and (report) https://1drv.ms/u/s!AlntzgQcvbvR2D4dmQDGa_jCakw7?e=Ly9r4s

[vivran22 · Accepted solution]

Hello @Anonymous 

The easiest way is to create a relationship between the two tables in the Model view:

In this, I have changed the filter direction to Single where Allocation table is filtering the Obligation table.

Result:

Hope this helps!

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[Anonymous]

@vivran22 You are the man.  Thank you so much for your tutoring!