cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dellis81
Responsive Resident
Responsive Resident

Keepfilter or userelationship?

Hello, I am needing help with measure that I thought "userelationship" or keepfilter would solve, but unable to make either work.  To start, the data is in a two table datamodel, with the dimension table having a single column labeled "Destination".   The fact table has two potential columns that should be related to the Destination.

 

Example pbix file:   https://drive.google.com/file/d/1-dVkDxCfSpzDjl_abvdmlb5e--v_Qczl/view?usp=sharing

 

Data is related to crop harvest and managing the loads.  And I am wanting to keep a simple inventory by destination.  But several options exists.

1) Harvest Field to Storage (Destination)

2) Harvest Field to Sales (Destination)

LoadLog Table

If Field has a value - then assume a harvest record

If Storage has a value - then assume movement from storage to sales destination.   Harvest1.PNG

 

Measures I have working/not working.   Basically the -25,170 needs to be moved into the GSF West (circled in Blue).   These bushels would be represented by data in the "Storage" and "Destination" columns

Harvest2.PNG

Below is the desired end result (please note, Sales Transfers is what I am looking to get to.   Bin transfers will most likely follow the same logic?

Harvest3.PNG

 

Hope this explanation is concise and clear enough.   As always - thank you for the great forum support!

1 ACCEPTED SOLUTION
Dellis81
Responsive Resident
Responsive Resident

Hello, I woke up with fresh mindset, and made a little progress.  Please wait till have a little more time to work thru.   Thanks

View solution in original post

1 REPLY 1
Dellis81
Responsive Resident
Responsive Resident

Hello, I woke up with fresh mindset, and made a little progress.  Please wait till have a little more time to work thru.   Thanks

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.