Forum Discussion
Solved
Blank values
Dear all, I have a fact table with columns of products , customers and sales another table containing discount rates for each product. Mostly one customer has only one product but in some cases mor...
Thulasiram Not sure I fully understand but try using MAXX(FILTER( ) ) instead of LOOKUPVALUE
Step 1: I add a relationship between a fact table and another table. (Key column: 'product')
Step 2: I add a column to a fact table.
discount rates = RELATED(another table[discount rates])
Thulasiram Not sure I fully understand but try using MAXX(FILTER( ) ) instead of LOOKUPVALUE
Thank, will try.
Hi,Thulasiram
Has the problem been solved? If it does, share your solution and accept it as a solution that will help other community members who have the same problem as you.
Best Regards,
Leroy Lu
