filter based on one column of a visual but how to show all relevant data from original data table

[fyoung]

I have some sample data like this:

SEQUENCE_NBR	CASE_ID	STATE	DEVICE_ID	DEVICE_TYPE	CAUSE_OF_TROUBLE	TOTAL_CUSTOMERS	ACTUAL_MINUTES	EVENT_TIME	UPDATE_DEPT	APPROVED_BY	APPROVED_DATE
8505866	1304508354	A	1391665	TF	V	4	180	4/1/19 9:08 AM			NULL
8505867	1304508354	A	1391665	TF	V	4	180	4/1/19 9:08 AM	NETWORK		NULL
8506715	1304512698	A	4051751393	OP	P	3	4509	4/1/19 10:45 AM			NULL
8506716	1304512698	A	4051751393	OP	M	3	4509	4/1/19 10:45 AM	NETWORK	WILLI	4/3/19 7:59
8506709	1304515661	A	372F	LF	H	10	1850	4/1/19 12:17 PM			NULL
8506710	1304515661	A	372F	LF	H	10	1820	4/1/19 12:17 PM	NETWORK	WILLI	4/3/19 7:58
8506707	1304528795	A	695515	TF	M	1	147	4/2/19 6:32 AM			NULL
8506708	1304528795	A	695515	TF	S	1	147	4/2/19 6:32 AM	NETWORK	WILLI	4/3/19 7:57
8506705	1304532851	B	1456T	LF	M	22	4202	4/2/19 9:34 AM			NULL
8506706	1304532851	B	1456T	LF	S	22	0	4/2/19 9:34 AM	NETWORK	WILLI	4/3/19 7:57
8506703	1304536185	B	422311	TF	M	2	12	4/2/19 11:24 AM			NULL
8506704	1304536185	B	422311	TF	S	2	0	4/2/19 11:24 AM	NETWORK	WILLI	4/3/19 7:57

I have a few slicers and show a brief table after slicer applied:

Now in another more detailed table, what I want to show is if I click the first case_id "1304541261"in the above table, I would it to show all rows in the original table which has case_id "1304541261", not only just that one row.

So this is what I want:

However this is what I get:

Any suggestion? Sample Data and pbix file are uploaded here. Thanks!

[v-juanli-msft]

Hi @fyoung 

When selecting one row of the table, it should only show that row by design.

I am working to find a workaround and will give another post when i complete it.

Best Regards
Maggie