Slicing on one column but getting results depending on another column

[Jensk]

I need to construct a way to filter rows by what ACCOUNT is selected. But I need to filter all rows with the same JE as the selected ACCOUNT.

Sample data:

JE	ACCOUNT
1	1000
1	4000
1	3020
2	2050
2	2060
2	3000
2	3010
2	3020
3	1000
3	3020
3	5020

In this example if ACCOUNT 3020 is selected all rows should be filtered because 3020 exists in all JE:

If ACCOUNT 1000 is selected all rows from JE 1 and 3 should be filtered:

In my report I would like to be able to slice on ACCOUNT and be able to see all rows with the same JE as the selected ACCOUNT in a table visual.

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[Jensk]

Thanks alot for the quick reply! Greatly appreciated