Use Inactive Relationship in Related function

[yasbos]

Hi. I'm using Addcolumns to add columns from a related table using Related like in the below example:

ADDCOLUMNS(  tableA  ,  "Date"  ,   RELATED(  tableB[OpenedDate])  ,  "AcctKey" , RELATED(tableB[AccountID]  )

the relationship between tableA and tableB is many from tableA to one in tableB: tableA *------ 1 tableB   

However, I have another inactive relationship between the two tables, where it is also tableA *------ 1 tableB  but on a different column in tableA. Is it possible to make the Related function in the above Addcolumns code use that inactive relationship instead of the active one? My data source is SSAS, btw, so I have certain limitiations, as i can't create physical tables or columns.

Thanks.

[amitchandak]

@yasbos , related will not work on inactive , if you need a column you can get like

maxx(filter(TableB, TableA[Col2] = TableB[COl2]), TableB[Col3]) //Or use sumx

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8