ADDCOLUMNS/SUMMARIZE for columns from different tables

[Pbiuserr]

Hello, 
My goal is to create a VAR _table which will contain

a) gender from table personal

b) product description from table product description

there is no link between these 2 tables, they are all connected to main table by either personID or productID

[AlB]

Hi @Pbiuserr 

I don't understand what you mean by "main table". Can you show a sample of the relevant tables and their relationships (including that "main table")? With the expected result

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Pbiuserr]

Well, fact table (can't share screenshots, sensitive data in column names)
So there are 3 tables
Fact table

Person table

Product description table

Person table is connected to fact table with personID

Product description table is connected to fact table with productID

My goal is to get a table that shows (for measure, so stored as VAR) 

Gender

Product description

My measure (change prior last month)

[v-chenwuz-msft · Accepted solution]

Hi @Pbiuserr ,

If you want do this with some filter by the relationships between fact table and Person table and Product description table, please change one of the relationships' cross filter direction to both.

If do not do this, it maybe complai to reatch that.

And after changing the direction, use meausre like the following:

var _s = summarize( 'Person table', [Gender],'Product description table'[Product description],"some column name", <expression>)

If you need more help, please share some example data and expect result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.