Need help with the Dax query

[Haripinnoju]

Hi,

I Require a dax query for the following requirement, it can be a calculated measure.

I have three tables (SharePoint lists files) into my power bi desktop, 

1. Supplier qualification list

2.vendorscontacts.

3.repair network

--->Supplier qualification list( Vendor ASL) (many to 1) relationship with vendorscontacts(ASLNO)

--->vendors contacts( country) (many to many) relationship with repair network ( map country)

Into repair network table I have basin geount and location columns

Into vendors contacts table I have country 

Into supplier qualification list table I have basin, geount and location columns.

As the country of vendors contacts is mapped to map country of repair network.

Some of the countrys do not have map country mapped, it means that they do not have those values into repair network table.

The condition is as we do not have the map country in repair network, that country needs to take the data from supplier qualification list basin geount and location checking with the mapped ASLNO.

Thanks for the help in advance.

[Anonymous]

Hi @Haripinnoju ,

Base on your description, it seems that you need to get the values from antoher table. Could you please provide some raw data in thse three tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards