Forum Discussion
Selected Value matrix help
Hi,
Is the scenario in the image below possible? There is 8 different countrows measures and 8 different distinct count measures that need to drill into the line level per measure number entry, without having a landing page for each measure.
I have looked two similar are yet to be solved, so was seeing if there was a workaround recently.
Drill Through with Measures on the rows - Microsoft Fabric Community
Solved: Drillthrough from measures in a matrix - Microsoft Fabric Community
Thanks
Liam
Hi lherbert501 ,
Thank you for the quick response.
Creating a native direct drill-through from 8 individual measures into one shared line-level page with out any helper field (like Measure Name or dynamic selection) is not possible natively. You need some helper mechanism to tell the report which measure context is being requested.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
5 Replies
Hi lherbert501 ,
Thank you for reaching out to Microsoft Fabric Community.
I have created a matrix table using two measures with sample data and added measures to the drillthrough fields sections on both the main page and the landing page. When I drill through to the landing page from the main page, I get the expected results. The pbix file is attached for reference.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
Hi v-sathmakuri ,
Thanks for your reply.
Unfortunately, as there is 18 measures and countrows have different filters e.g. colour = blue and size = large, this will not work in the attached.
If there was one measure this would be no problem, but I also can't contain 18 measures on my drillthrough tablix.
Thanks
Liam
Hi lherbert501 ,
Thank you for the quick response.
Creating a native direct drill-through from 8 individual measures into one shared line-level page with out any helper field (like Measure Name or dynamic selection) is not possible natively. You need some helper mechanism to tell the report which measure context is being requested.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
