cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

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

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 ->

1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Helper I