Drillthrough from measures in a matrix

[dkernen]

Hello.  I have a matrix with has a category as the columns and many measures as rows.  When I drill through on a cell (example FV in February with 20) I expect to see only 20 rows, but instead it only keeps the categorical report month (this has no need for a date table) and gives me ALL rows (in this case 241).  How can I have it drill though to only the records which met the measure criteria?  I am only want to drill though on the COUNTS (Recovered, Errors) not any of the rates.  PBIX link below.  Many thanks in advance!  

	Jan	Feb
FV Recovered	23	20
FV Errors	4	2
FV Error Rate	17.4%	10.0%
SV Recovered	45	68
SV Errors	3	11
SV Error Rate	6.7%	16.2%
Tissues Recovered	222	241
Tissue Errors	51	48
Tissue Error Rate	23.0%	19.9%

https://mwtn-my.sharepoint.com/:u:/g/personal/dkernen_mwtn_org/EQrc_3FE3a9Ev0c_Yd1nQqoBCnyBIB3UVLUEw... 

[parry2k · Accepted solution]

@dkernen because you have another measure in the drill thru page which is not getting filtered, in attached I created a separate drill thru page with FV recovered measure and if you drill on that, you will only see 20 records.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Mattkarim9908]

Hi Parry,

Will this work if the metrix has multiple measures as well. Since your created sheed had only one measure there. What if I have more than 1 measure in the table, will it drillthrough as per the command and give correct result?

[dkernen]

Thank you!  I was hoping to not have a separate drill-through for every measure.  I will look at your calculation groups to see if I can make that magic work!

[Mattkarim9908]

Hi,

Would like to know if it worked for you. I am facing same kind of issue wherein I am trying to drillthrough my table which has many measures.