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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors