Drill thorugh :- When i select drill through measure from one page it should populate that measure.

[Anonymous]

Hello Team,

         I have a requirement in drill through. In first page i am having 10 measures with one matrix and 5 years as columns in same matrix. So what i am done i have created second page using drill through of 10 measures coming from first page. In my previous requirement in second page that is drill through page havign one table and we are showing all 10 measures as columns in that table for second page. Now drill through is working fine but here requirement has changed and below is one.

New requirement:-
1. Instead of having 10 measures in second page table we need only one column and dynamically should change based on selection from first page by user.

  Ex:- When user selects any particular measure i.e 8th measure from first page and drill through to second page. 

     In second page table having 3 columsn First_Column, Second_Colum, Measure _Name . This Measure _Name column should change based 8th measure selection dynamically including Measure_Name and Data in that column.

Please suggest me any ideas.  

[Anonymous]

@parry2k  Hello Mate,

     thank you so much for your replay. I tried from my side but not working as expected and if you have any reference it really help me.

[parry2k · Accepted solution]

@Anonymous you can use calculation groups to achieve this, check this video to get an idea how it can work https://youtu.be/u_4mkEAjHEA

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.