Drill through from Random Card Visuals

[abssenthil_pbi]

Hi, 

I have arould 10 cards placed on top of the report like Opened_tickets, Closed_tickets, Backlog_tickets... and I have a detail page with ticket_number. The above 3 are calculated measures placed on cards with different conditions.

I would like to enable drill through from each card to the detail page. I know that we can place all these measures in the detail page, which enables the drill through on all these cards.

But the problem is the filtering is not happening correctly on the detail page. It always returns the same no of rows/tickets as it passes only the slicer selections and not the conditions applied on the measures. 

we can achieve by placing the measure in detail page as a filter and select notblank/1, this will work perfectly if we have just 1 card on summary page. but in my case i have around 10 cards and if i place all measures in detail page filters then it will not return correct rows as one or the other measure will have 1 for the same row.

So i am thinking to create 1 measure based on all these 10 measures placed on cards and dynamically identify which measure has been selected for drill through and apply filter on this measure on the detail page.

Can someone help me to create a dynamic measure which will return the measure value of selected card?

PBIX can be downloaded from the below link

https://drive.google.com/file/d/15wbfzigEQ1mKS7d1CGQM7gA52rmA-G4Y/view?usp=sharing

Thanks, Senthil

[amitchandak]

@abssenthil_pbi , These two should help

Card Drill through: https://www.youtube.com/watch?v=VBRUiGeV6I4

Power BI Drill Through when Userelationship is used: https://youtu.be/1BM_WGATrQA

[abssenthil_pbi]

Hi @amitchandak ,

Thanks for the quick response. Unfortunately these 2 links did not help my requirement. According to the links i need to create seperate details page for each measure, which is something not agreed by business. They wants to have just 1 detail page.