PowerPivot(Excel2010): DAX-Formula referring to multiple tables

[ChristianKörner]

Hello everyone,i'm dealing with the following issue: In a measure I want to refer to more than one table in a dax formula in order to calculate this values. There is an one-to-many-relationship between the tables. When I tried this, message is that one of the fields isn't available in the given context. Is it in general possible to use different table sources for a DAX formula?Thanks,Christian

 

[miguel.escobar]

when referring to a related column or table try using this prior to the columnname/tablename
RELATED ( Column name)
RELATEDTABLE (table name)

you should post a sample of your workbook so we can get a closer look at it