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...
Hi Greg, FYI I encountered the same problem today for the first time, and your MAXX workaround worked fine for me as well.
Similar scenario where I was trying to add a lookup in my Spend Fact table to lookup a value in the Contract Fact table. Spend Fact not directly related to Contract Fact, and not filtering any other tables, but is filtered indirectly by tables that also filter and are filtered by Contract Fact.
I also tried creating a new calculated table with no connections summarizing the column from my Spend Fact that I'm using as the lookup search value and was able to return the expected value, so it does appear that the issue is related to the table relationships - very strange that it should be affecting calculated columns!