Drill Through looking at wrong data

[GunnerJ]

I'm using a measure as my drill through criteria, but when I drill through my chart it brings up the incorrect dataset. 

The visual is showing the number of Service Orders closed in a given month but is showing the values for those opened in the given month. In the photos below I'd expect 7 results but are only shown 4. 

These are the calculations in question. The first one shows the count of open service orders and those values are showing in the drill through. I have "Closed" in the drill through filters for the drill through page but it's seemingly not being followed. 

Opened = DISTINCTCOUNT(Workflow[BI_SO_NBR])

Closed = CALCULATE([Opened], USERELATIONSHIP(Workflow[BI_CLOSE_DT],Dates[Date]))

Any help would be greatly appriecited. Thanks! 

[d_gosbell · Accepted solution]

Measures are not used as filters in drillthrough operations. When you add a measure to a drillthrough page you are really just saying that any visuals using this measure should show this page in the drillthrough menu.

So in your example the date filter and type filter will get passed to the drillthrough page, but the table will be using the active relationships. One simple fix for this would be to add the [Closed] measure to the table on the drillthrough page.