Drill through from selected value in matrix

[neek05]

Hi,

I'm trying to create a drill through from a Card visual. The card value for the drill through should be the selected value in the matrix.

I'm using this measure in the card and in the drill through page: 

SelectedValue = SELECTEDVALUE('Table'[FromRecord])

In the drill through page the value passed in the card is correct but I'm getting the incorrect row in the matrix. I want to filter the row 2, not the row 4. 

I think I'm making some silly mistake in the measure, but I'm new to Power Bi, so I have no idea. Also, I think I can achieve the same result if a duplicate the table and create a relationship between them, but I'm trying to avoid that. I'm attaching an example. Can anyone help me with this? Thank you! 

[Anonymous]

Hello @neek05 ,

I think the value you are getting in drill through is correct as in the 1st image you have selected the row having the RecordNumber value as 4 and RecordNumber value as 2 which is matcing in 2nd image.

Please let me know if my understanding is not correct.

[neek05]

Thank you, 

But, could it be possible to get the value of row 2 (RecordNumber =2, Status= A), instead of RecordNumber=4, Status=C?

[Anonymous]

Hello @neek05 ,

Then you will need to drill through 2nd row becuase drill through applies the filter to the page from which it is been navigated.

Thank You!