Forum Discussion
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...
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
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
Thank you very much for your help and clarification. 🙂