Forum Discussion

bstark1287's avatar
bstark1287
Helper II
2 years ago

Inventory Report Drill Through

I have created a dummy pbix which has inventory transactions with dimension tables. I have the data showing in a method in which I need it reported. The issue I am having is since I am using a running total measure when I go to drill through, it will pull all inventory transactions that have occurred up to that date. The solution I am looking for, is to be able to drill through my visual and have my drill through only return the list of inventory that was on stock during that time. For example in my dataset if I drill through April 2021 I want the drill through to only show 15 rows (that should be what is remaining on stock at that time.) 

 

 

https://www.dropbox.com/scl/fi/lgzvmf37npwpk6a10zcym/Fruit-Inventory-Transactions.pbix?rlkey=tda3ah59q7ix6hkh6r1rjuw5g&dl=0

No RepliesBe the first to reply