Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
bstark1287
Helper II
Helper II

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=tda3ah5...

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors