Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Jatin77
Helper I
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.

PhaseGroupMarketSub-MarketMembersGeoSub-Market ScoreVariable 1 pointerVariable 2 pointerVariable 3 pointer
21BB1JulianGN2461.51.51.1
21BB1LucianGN2461.51.51.1
21BB1AriaGN2461.51.51.1
21BB1IsaiasGN2461.51.51.1
22BB2KristianGN2882.32.12.2
22BB2BennettGN2882.32.12.2
22BB2AriannaGN2882.32.12.2
22BB2AddisynGN2882.32.12.2
23CC1SonnyGN3141.82.52.2
23CC1SaniyahGN3141.82.52.2
23CC1JenniferGN3141.82.52.2
23CC1JefferyGN3141.82.52.2
24CC2ReneeGN381332.45
24CC2ConnerGN381332.45
24CC2DarnellGN381332.45
24CC2NataliaGN381332.45
24CC2KoltenGN381332.45
1 Hy  GN171   
1 HoHo GN136   
1 CoCo GN255   
1 GG GN389   
1 BB GN264   
1 CC GN340   
1 DD GN244   
1 HiHi GN185   


 Now I have created a calculated column -


Jatin77_1-1713432585894.png

 

and a measure ->
 
Jatin77_2-1713432625833.png


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

Jatin77_0-1713432485915.png


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

Jatin77_3-1713432836900.png

 

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

Jatin77_4-1713433155529.png


Drill through page result->

Jatin77_5-1713433223817.png
but ideally it should have been like this ->

Jatin77_6-1713433294404.png

1 ACCEPTED SOLUTION
v-binbinyu-msft
Community Support
Community Support

Hi @Jatin77 ,

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

vbinbinyumsft_0-1713505975653.png

Animation05.gif

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.

View solution in original post

2 REPLIES 2
v-binbinyu-msft
Community Support
Community Support

Hi @Jatin77 ,

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

vbinbinyumsft_0-1713505975653.png

Animation05.gif

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

@amitchandak @lbendlin can you please help here?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.