Data from one or another column but merged

tamerj1Hi,

Sorry let me try again:

So we have 3 entities: contact, account and donation.

When the amount from donation is linked to contact (so it's a person who donated) then it is populating the Business Region for contact but is blank for account.

And when the donation is coming from an account (a business/organization etc) the business region is populated for account entity and is blank for contact.

I basically need to get those two fields of Business Region populated in one field.

So as example let s say:

Jon Doe donated 6 euro and he is from London  (only contact Business Region field is populated as this is contact)

and Analytics ISO company donated 7 and location is Belfast (only account Business Region field is populated as this is account)

My output should be:

Donor                    Business Region          Amount

Jon Doe                 London                           6

Analytics ISO         Belfast                             7

Hope now makes sense.

Many thanks

adoalan 

Ok. This is because the active relationship has the cardinality that does not help this calculation. I have no idea what columns are involved in which relationship but let me give it a wuick guess. Please try something like. 
Business Region =
RELATED ( contact[Business Region] ) &

CALCULATE (

MAX ( account[Business Region] ),

CROSSFILTER ( nfp_donation[column1], account[column1], NONE ),

USERELATIONSHIP ( contact[column2], account[column2] )

)

So CROSSFILTER - NONE to deactivate the active relationship and USERELATIONSHIP to activate the inactive (1 to 1) relationship