Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
1 year ago
Solved

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, w...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

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

lherbert501's avatar
lherbert501
Post Prodigy
1 year ago

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's avatar
v-sathmakuri
Community Support
1 year ago

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

  • lherbert501's avatar
    lherbert501
    Post Prodigy
    1 year ago

    Hi v-sathmakuri 

     

    Okay thankyou for confirming. 

     

    Would you recommend any sort of workaround?

     

    Thanks again

     

    Liam

  • v-sathmakuri's avatar
    v-sathmakuri
    Community Support
    1 year ago

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