Forum Discussion
LOOKUPVALUE 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...
Yeah, 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.
Greg_Deckler bit confused, your original post says FACT_Inventory related with Dim_Product, many to one
In your relationship, don't see FACT_Inventory??
Sorry, fact_Inventory = Inventory_v