Drill through on inactive relationship

[Anonymous]

I am still having problems on drill through on inactive relationships.

Say I have 3 tables. People. Sales and Calendar. I have two dates in my fact sales table -  Date Bought and Date Dispatched. So have an active relationship on Bought and Inactive on Dispatched.

I have a drill through page - which is a card showing count of sales and a table listing people and the same measure showing their sales.

I have measures that with user realtionship which correctly counts sales by date bought and a measure sales by date dispatched.              

Can I get my drill through page to list sales dispatched or sales bought. I have added each measure to the drill through on teh target page.

I have added each measure to the drill through box on teh drill through report. 

So dill through is an option. However

 I need to limit my table to only those people with a measure > 1.Otherwise my table is just all people?       

 How do I tell it which measure. 

How do I tell the card which measure it should be showing? Because a simple sales count uses the active relationship - when sometimes I am interested in the inactive one?

Thanks.

[v-diye-msft]

Hi @Anonymous 

Data is too scarce to recur your issue.

You might refer to the similar drillthrough on measure threads:

https://community.powerbi.com/t5/Desktop/Drillthrough-on-measure-with-dax-filter-context-not-working/m-p/743205 

Or you can just use the bookmark to achieve the requirement:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks 

[Anonymous]

Thanks - is myself posting a small mock up pbix with where I am at an option here? I think that demonstrate the problem. I am sure its one that i sencountered all the time. None of the other reading has led me to a solution yet?  Thanks

[v-diye-msft]

Hi @Anonymous 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.