Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.)