topic How to use a slicer from one table to filter records in another table in DAX Commands and Tips

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

Anonymous — Thu, 17 Sep 2020 00:52:08 GMT

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

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

vivran22 — Thu, 17 Sep 2020 01:44:53 GMT

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

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

Anonymous — Thu, 17 Sep 2020 12:34:37 GMT

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