calculated column from unrelated tables

[Anonymous]

Hi, 

I have 2 tables with and both have a column with the same number.

There is no relationship "line " between these to table but i still can make a calculated columns in one table the use of 

SUMX(tableA:tableA(columnX=tableB(columnX);tableA(columnC)

How is this possible without a relationship?

Is there a automatic relationship in the background??

[v-chuncz-msft · Accepted solution]

@Anonymous 

You've applied virtual relationship in DAX expression.

https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/

[amitchandak]

Can you Try Union and summarize. Link

Summary Table = UNION(SUMMARIZE('Original data','Original data'[IDRun],'Original data'[User 1],'Original data'[SecUser1],"User",1),SUMMARIZE(FILTER('Original data',not(ISBLANK('Original data'[User 2]))),'Original data'[IDRun],'Original data'[User 2],'Original data'[Sec User2],"User",2))

his can used in the formula you can use this as a new table