Forum Discussion
Advocate IIStock on Hand (Inventory) With Missing Dates for Multiple Sites
Hello @McGran ,
Create a dim table as shown below:
Dim = VALUES('ODS STOCK_LINECODE_DC'[LOCATION_KEY])Next, create a relationship as shown below:
Finally, create a measure as follows:
Measure = SUMX(VALUES(Dim[LOCATION_KEY]),[STOCK ON HAND])And you'll see:
For the related .pbix file, see pls see attachment.
Saludos
KellyDid I answer your question? Mark my position as a solution!
Microsoft EmployeePlease try this expression, substituting your actual table and column names
New Measure = SUMX(VALUES(Table[Location), [Stock On Hand])
Where Location is the column with Loc1, Loc2, and Stock on Hand is your "Current Measure" that give correct values in the columns (but not the row total).
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
McGranThank you for the reply.
I can understand what you're trying to do here (and got my hopes up) but, unfortunately, this too results in the blanks reappearing as per table 1.
v-kelly-msftCommunity Support
Hi McGran ，
It's a grandtotal issue ,very common issue. Could you pls upload your .pbxi file to onedrive business and share the link with us?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!- McGran
Here is a onedrive personal link. I can't share business links outside of my organisation.