drill through from 2 separate measures to the same detail page?

[jd8766]

Hi, I have the below 2 cards..

The cases card has a measure on it which is countrows(cases), the breached cases has a measure which is calculate([total cases], isbreached=true())

I want to be able to right click the 974 and it takes me to the detail page I have built which shows me case name, assigned user, created date etc for the 974 cases, however each time I do this it just brings me back everything.

Is there something I am missing? Can this even be achieved I would I need a separate detail page per measure?

[Ritaf1983 · Accepted solution]

Hi @jd8766 
To make the "filtered" measure's drill work you need to put it on drilled table 2, it will give to it the filter context.

For example breached cases :

All cases:

Link to the file with an example 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly