How to filter with 2 columns

[Anonymous]

Hi All,

I have 2 tables.

1. Employee-Trainings

2. Events

I have keys for employees and events in the first table, and the same in the second table.

When I filter Employee according to EMP_ID in the first table, I am getting all records for that employee in the second table, which is great.

Now, I want to filter again according to EVENT_ID.

How should I achieve this?

For example:

Employee training will look like this:

EMP_ID	Data1	Data2	EMP_EVENT_ID
1	aaa	vvv	1070
2	aaa	vvv	990
3	aaa	vvv	12
1	aaa	vvv	2502
4	aaa	vvv	56
5	aaa	vvv	48
5	aaa	vvv	203

Events will look like this

EMP_ID	Data1	Data2	EVENT_ID
1	bbb	nnn	1070
2	bbb	nnn	990
3	bbb	nnn	12
1	bbb	nnn	2502
4	bbb	nnn	56
5	bbb	nnn	48
5	bbb	nnn	203

If I slice/filter by employee ID = 1 I will see the following:

EMP_ID	Data1	Data2	EMP_EVENT_ID
1	aaa	vvv	1070
1	aaa	vvv	2502

AND

EMP_ID	Data1	Data2	EVENT_ID
1	bbb	nnn	1070
1	bbb	nnn	2502

I want to press the records and filter again by event ID.

So the result will be (The bold record is clicked):

EMP_ID	Data1	Data2	EMP_EVENT_ID
1	aaa	vvv	1070
1	aaa	vvv	2502

EMP_ID	Data1	Data2	EVENT_ID
1	bbb	nnn	2502

By the way, I tried to create a second relationship and got the folloiwng message:

Thanks!

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, you could refer to below relationships:

Create a table with [EVENT_ID] column:

Table = VALUES(Events[EVENT_ID])

Create two relationships between 'Table'[EVENT_ID] with other tables[EVENT_ID]:

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[Anonymous]

@v-danhe-msft 
Amazing!
Works like charm.

Thanks a lot 

[Anonymous]

I will try to rephrase.

I am filtering both tables by employee ID.

Then I want to press one record in the employee table and get the coresponding records in the second table of events. Is that possible?

Thanks!

[Anonymous]

This video demonstrates the final result I am after:
https://www.youtube.com/watch?v=VomATEQFBoo