Blank values

[Thulasiram]

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 more than 1 product.

I have a dim table containing customer names.

I want to bring in the product name against each customer through lookupvalue function.

Since some customers has more than 1 prouduct, the result show error.  I used IFERROR function

to show blanks in those cases where customer has more than 1 product.

I calculated discount amount by calculating sales from one table and discount rate from another table.

Since my dim table contains blank values for products against some customers, the rows contains

blank values but discount is properly calculated.

Is there any way I can bring in the product names?

Help is much appreciated.

[Greg_Deckler · Accepted solution]

@Thulasiram Not sure I fully understand but try using MAXX(FILTER( ) ) instead of LOOKUPVALUE

[mickey64 · Accepted solution]

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]

Thank you

[Greg_Deckler · Accepted solution]

@Thulasiram Not sure I fully understand but try using MAXX(FILTER( ) ) instead of LOOKUPVALUE

[Thulasiram]

Thank, will try.

[v-linyulu-msft]

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