Drill Through not filtering the data as per the values in the matrix table

[Jatin77]

I have a below data in power bi in single table.

Phase	Group	Market	Sub-Market	Members	Geo	Sub-Market Score	Variable 1 pointer	Variable 2 pointer	Variable 3 pointer
2	1	B	B1	Julian	GN2	46	1.5	1.5	1.1
2	1	B	B1	Lucian	GN2	46	1.5	1.5	1.1
2	1	B	B1	Aria	GN2	46	1.5	1.5	1.1
2	1	B	B1	Isaias	GN2	46	1.5	1.5	1.1
2	2	B	B2	Kristian	GN2	88	2.3	2.1	2.2
2	2	B	B2	Bennett	GN2	88	2.3	2.1	2.2
2	2	B	B2	Arianna	GN2	88	2.3	2.1	2.2
2	2	B	B2	Addisyn	GN2	88	2.3	2.1	2.2
2	3	C	C1	Sonny	GN3	14	1.8	2.5	2.2
2	3	C	C1	Saniyah	GN3	14	1.8	2.5	2.2
2	3	C	C1	Jennifer	GN3	14	1.8	2.5	2.2
2	3	C	C1	Jeffery	GN3	14	1.8	2.5	2.2
2	4	C	C2	Renee	GN3	81	3	3	2.45
2	4	C	C2	Conner	GN3	81	3	3	2.45
2	4	C	C2	Darnell	GN3	81	3	3	2.45
2	4	C	C2	Natalia	GN3	81	3	3	2.45
2	4	C	C2	Kolten	GN3	81	3	3	2.45
1		Hy			GN1	71
1		Ho	Ho		GN1	36
1		Co	Co		GN2	55
1		G	G		GN3	89
1		B	B		GN2	64
1		C	C		GN3	40
1		D	D		GN2	44
1		Hi	Hi		GN1	85

 Now I have created a calculated column -

and a measure ->

and placed -> Phase, Distinct count of market, Distinct count of Sub-market and #Market scored less than 50

Now I ahve added a dril through page which has below table and all the drill through filters are added on this page->

Now the problem I am facing is when I am trying to drill through from one of the values under #Market scored less than 50 and go to drill through page, I am still seeing all the entries and not the filtered entries for score less than 50.
For ex. I have drilled through on value 3 from pahse 1 and the I goot below result on drill through page ->

Drill through page result->

but ideally it should have been like this ->

[v-binbinyu-msft · Accepted solution]

Hi @Jatin77 ,

Please add the measure to the table visual filter pane and set in Page 2.

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jatin77]

@amitchandak @lbendlin can you please help here?