Forum Discussion
RELATED function for Many to One relationship doesn't work. How else to create a calculated column?
Hi everyone, I have 2 tables (dps_contact_role and dps_customer) related to each other like this: I am trying to calculate how many customers are missing customer contact ID (which is call...
Hi Anonymous ,
You can created a calculated column as below in the table 'dps_customer' to get it, please find the details in the attachment.
Customer Contact = VAR _ciid = CALCULATE ( MAX ( 'dps_contact_role'[contactidentity_id] ), FILTER ( 'dps_contact_role', 'dps_contact_role'[cutomer_id] = EARLIER ( 'dps_customer'[id] ) ) ) RETURN IF ( _ciid = BLANK (), "Contact Missing", "Contact OK" )In addition, you can review the blogs below to know the applied scenario of RELATED function...
Best Regards
If you sit at the M side of a M:1 relationship you can use RELATED as it will always return one or zero results. For all other scenarios you need to use RELATEDTABLE and then boil the result down to a scalar value.
thanks lbendlin
I sit on 1 side, not M (that's the problem). But how could I use RELATEDTABLE in this case? if you could help with that
Thanks