Drill through on measure with conditions

[Ben1981]

Hi, 

I have a line chart with a fairly simple measure that does a count with a filter and the filter will change depending on a slicer selection. So my calculation is as below: 

Measure =

VAR _Selection = SELECTEDVALUE(''Table'[STATUS])

VAR _New = CALCULATE(COUNT('Table'[UID]),'Talble'[CAT]="New")+0

VAR _Used = CALCULATE(COUNT('Table'[UID]),'Talble'[CAT]="Used")+0

RETURN

if(_Selection = "New",_New,_Used)

My problem comes with a drill through, I need to be able to drill through to another page with either the new or used based on the selection criteria but this isn't being carried across. Any ideas on how to make this work? 

Also bookmarks isn't an option in my case.

Any help would be apreiciated.

Thanks

Bem

[Ben1981 · Accepted solution]

Sorry I actually solved this myself, it turns out it was a really simple thing. I just had to add the status field to the visual as a filter and set it to both conditions and this sorted it. 

So simple and yet it was the last thing I tried, doh!