Drill down from Card or Button based on measure
You should be able to take a measure and display the result to a clickable widget (Card or new button). Then when the user clicks the widget, it behaves like a filter. This would allow a table to then display those corresponding records in the report.
STATUS
DETAILS
New