do not refer to another column in another table that is not related to the current table using dax

[Anonymous]

Currently I have two tables that are independent and THERE IS NO RELATIONSHIP between them.

Therefore, I cannot use the RELATED DAX function.

Do I have to create a relationship? Or could there be another function

More details : what I want is to calculate the % of completion :

% réalisation_exploitation (HSEDATA[Management Security Visits]*100)/RELATED(HSETARGET[Management Security Visits])

and there are the tables that I have:

[Ashish_Mathur]

Hi,

You may be able to use the LOOKUPVALUE() function.

[amitchandak]

@Anonymous ,

From City to sales

City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])

From sales to City

City Name = Sumx(FILTER(Sales,geography[City Id]=Sales[City Id]),Sales[Amount])

In filter you can add conditions as per need

[Anonymous]

I'll give more information to explain the problem

[lkalawski]

Hi @Anonymous

Yes, to use RELATED function you have to have a relationship between tables.

Can you share what do you want to achieve? Maybe we can find another solution. 

_______________
If I helped, please accept the solution and give kudos! 😀