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
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
Anonymous HUGE thanks!! That solution worked perfectly 🙂