Forum Discussion

liselotte's avatar
liselotte
Advocate I
1 year ago
Solved

Create a measure with LOOKUPVALUE

I have the following tables: - dimension table dim_customer with columns: Customer UID, Customer Name - dimension table dim_country with columns Country, Customer Name, Account UID (each Customer N...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi liselotte ,

    If you create the relationship between the table 'dim_country' and 'fact_amount' base on the field [Account UID], it will return the NULL value for Cust02. Please remove the relationship just as shown in below screenshot.

    Best Regards

liselotte's avatar
liselotte
Advocate I
1 year ago

Hi Rena Anonymous ,

Thank you for your kind support. When I set up relationships as I mentioned in your provided file. The table doesn't show the Country for Country2

Could you please make it show Country02?

  • liselotte's avatar
    liselotte
    Advocate I
    1 year ago

    Anonymous  In your screenshot, it still doesn't show "Country2" in column "Country". Could you please check it again?

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi liselotte ,

      If you create the relationship between the table 'dim_country' and 'fact_amount' base on the field [Account UID], it will return the NULL value for Cust02. Please remove the relationship just as shown in below screenshot.

      Best Regards

      • liselotte's avatar
        liselotte
        Advocate I
        1 year ago

        Thank you very much for your help and clarification. 🙂