Forum Discussion
Power BI Table viz incorrectly creating multiple rows per dimension value
In my Power BI Model I have ItemStoreOuts table which has items and stores and various facts. This table connects to the Product table and ProductKey and the Store table on RetailKey. Product and St...
lbendlin
Super User
Super UserYou have a multi-path with Product->DepotInventory and Product->DepotAlignment->DepotInventory.
Yes but how do i avoid it? i need to be able to see DepotUnits (for an item-store combination) at it's aligned depot.... which is what i'm trying to do in this example. Elsewhere in my report I also need to see Total DepotUnits for an item regardless of store (so this Total would be from all Depots that that item can be stocked in).
- lbendlin
Use measures and TREATAS