Forum Discussion
Greg_Deckler
Community Champion
Community ChampionLOOKUPVALUE and Random Blanks
OK, I can't share the actual source data so I will try to be very clear.
I have fact_Inventory table like this:
Product_Key
367
367
367
444
I have another table, dim_Product tha...
Greg_DecklerCommunity Champion
Community ChampionYeah, can't use RELATED in LOOKUPVALUE. Plus, there is not relationship in that direction.
Yes, just trying to get the ID into the table, saves on measure calculations/processing not having to look those up on the fly every time.
It's mind boggling. Wish I could share the PBIX file as I am wondering if it has something to do with the scale of the data.
Here is an image of the model, perhaps someone can see a relationship that is causing an issue, I don't see it. Inventory filters nothing.
parry2k
Super User
Super UserGreg_Deckler bit confused, your original post says FACT_Inventory related with Dim_Product, many to one
In your relationship, don't see FACT_Inventory??
- Greg_Deckler
Sorry, fact_Inventory = Inventory_v