Hello @Usates,
Thank You for posting your query onto the Forum.
Well, the column that you’re trying to create is in a dimension table i.e., “one side” of the relationship. “RELATED()” function works towards the “many side” of the relationship. That is, it’s used to retrieve value from the dimension table to the fact table and not vice versa.
The reason why it’s not working in your case is because Customer table is the dimension table and Summarize table is the fact table and you’re trying to create a column using the “RELATED()” function inside a dimension table. Below is the link of the documentation as well as link of a video provided for the reference.
If you want to create a calculated column inside the Customer table then you can try using the “LOOKUPVALUE()” function.
Hoping you find this useful and helps you with the understanding why “RELATED()” function is not working in your scenario.
Thanks and Warm Regards,
Harsh
