The column either doesn't exist or doesn't have a relationship to any table available

[jn123]

Okay, I am at my wits end... 

I am trying to create a table that can be used to sort a column in another table.

This is the new table titled LN Sort:

And this is the column I am trying to sort in Table1:

This is the relationship I have set up for the two tables:

Whenever I try to create a new measure in Table1 to sort the Local News Sorting column using this formula: LN Sort = RELATED('LN Sort'[Order]), I keep getting this error message: 

"The column 'LN Sort[Order]' either doesn't exist or doesn't have a relationship to any table available in the current context."

I have gone back a million times to make sure I am doing everything right... so what could I possibly be missing??

Thanks,

[PijushRoy · Accepted solution]

Hi @jn123 

In place of measure, please create Calculated column and LN Sort = RELATED('LN Sort'[Order]). Then, click the "sort by column" button, select LN Sort. 

If you have any question, please let me know.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[VahidDM · Accepted solution]

Hi @jn123 

Check this link:

https://docs.microsoft.com/en-us/dax/related-function-dax

Note: The RELATED function needs a row context; therefore, it can only be used in calculated column expression

Try to use that formula to create a calculated column:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[PijushRoy · Accepted solution]

Hi @jn123 

In place of measure, please create Calculated column and LN Sort = RELATED('LN Sort'[Order]). Then, click the "sort by column" button, select LN Sort. 

If you have any question, please let me know.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos