Related function

[smishra99acres]

Hi i have build a rleationship in two table now ehen i am trying to created related fucntion its saying column not exist or dont have any relationship.

can any one please help me in thisi?

[Anonymous]

Hi @smishra99acres ,

Thanks to Pragati11 and rohit1991 for their quick replies. I have some other thoughts to add:

It worked fine through my tests. Can you provide example input data for both tables (please be careful to protect private data).

In addition to this, care should be taken when using the RELATED function:

(1) This is my test data.

(2) Create a new column.

Best Regards,

Neeko Tang

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

[rohit1991]

Ensure the relationship between the tables is correctly set up in the Model View, with matching data types for the related columns. Use fully qualified column names in your DAX formula, like:

NewColumn = RELATED(Table2[ColumnName])

If the issue persists, refresh the data model, recheck column names, and confirm there are no typos.

[smishra99acres]

NewColumn = RELATED(Table2[ColumnName])

same i am using in related auto suggestion also coming when i am trying to save  it then this issue arises.

both column are text which is used on retion in data model.

[Pragati11]

Hi @smishra99acres ,

Can you kindly add more details to your query please?

RELATED dax function is used when you are trying to create a calculation using two related tables. It will be nice to see a screenshot of your relationship between 2 tables along with the dax expression that is giving you error.

Please check the details on how RELATED dax function works in Power BI through the blog:

https://radacad.com/get-a-field-value-from-a-related-table-in-power-bi-dax-related-function-explaine...

Some guidelines around how to get your query answered properly on this forum:

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[smishra99acres]

Using above one and in auto suggest box mobile no is coming when i tried to save it then  below msg appears.

The column 'lead[Mobile No.]' either doesn't exist or doesn't have a relationship to any table available in the current context.

Column data type is text in both and link is created with same column.