if he finds value in the relation, brings the description, if not, use value from the origin table

[brunozanoelo]

I have two different tables, they are related, what I need is, if he finds value in the relation, brings the description, if not, use one value from the origin table;

Sample:

Customer A = > Group of Customers 1
Customer B = > Group of Customers 2
Customer C

Group of Customers:
Group of Customers 1
Group of Customers 2

Result:
Group of Customers 1
Group of Customers 2
Customer C

It is possible?

[brunozanoelo]

@lbendlin Hello my dear friend, sorry for my delay, I was creating sample data and cleaning all the dashboards, leaving only the situation that I have doubts.

My PBIX file is here:
https://drive.google.com/file/d/12nFJBE8_Rrli0QPWY2bqnNu93LOKxHm1/view?usp=sharing

What I have today:
Grupo de Empresarial (multiples clients);
Clientes (clients)

What I need: 
For the client´s that Don´t have relation with any Grupo Empresarial, appear as his own name in the agrupment; Today, they appear as a blank register in the Grupo Empresarial agrupment, since there´s no relation with any register.

Best Regards,

[lbendlin]

There are many ways to do that, my preferred way is via COALESCE

see attached.

[brunozanoelo]

I need to return one value from the WORKING table if DAX can´t find one value in the related table.

YesNoIfFoundInOtherTable =

IF(

ISBLANK(

LOOKUPVALUE('Related Table'[Key], 'Related Table'[Key], WorkingTable[Key])

),

WorkingTable[DESCRIPTION], 'Related Table'[DESCRIPTION]

)

How it is possible?

[lbendlin]

second request: Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...