Selected Value matrix help

[lherbert501]

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

[v-sathmakuri]

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

[lherbert501]

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

[v-sathmakuri · Accepted solution]

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

[v-sathmakuri]

Hi @lherbert501 ,

May I ask if the provided response addressed your issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you!!

[lherbert501]

Hi @v-sathmakuri 

Okay thankyou for confirming. 

Would you recommend any sort of workaround?

Thanks again

Liam