DAX help

[mikeborg82]

I am trying to create a new measure based on two other columns.  I want to create a column that tells me the average increase of salaries... I have both before and after.  When I create the DAX column I cannot seem to get any fields from that table into the formula.  I have tried closing, refreshing, etc... Any ideas of what I can do. This is the first time Ive had this happen.

Thanks.

[Greg_Deckler · Accepted solution]

Try using RELATED or RELATEDTABLE

[Greg_Deckler · Accepted solution]

Try using RELATED or RELATEDTABLE

[mikeborg82]

That works.  Thanks for your help.  Can you explain what it was doing?  I am pretty new to powerbi.

[v-ljerr-msft · Accepted solution]

Hi @mikeborg82,

Remarks

The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table. If a relationship does not exist, you must create a relationship.

When the RELATED function performs a lookup, it examines all values in the specified table regardless of any filters that may have been applied.

Note
The RELATED function needs a row context; therefore, it can only be used in calculated column expression, where the current row context is unambiguous, or as a nested function in an expression that uses a table scanning function. A table scanning function, such as SUMX, gets the value of the current row value and then scans another table for instances of that value.

---

For more details about RELATED and RELATEDTABLE function, you can refer to the following two articles. 

https://msdn.microsoft.com/en-us/library/ee634202.aspx

https://msdn.microsoft.com/en-us/library/ee634226.aspx

Regards

[Greg_Deckler]

Typically when creating DAX custom column is that the context is constrained to the table that you are in. To change context, one can use things like RELATED and RELATEDTABLE to change the context in which the DAX operates.