cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kintela Member
Member

RELATED Function does not shows me the related tables

Hi
I have a Projects table related with the Employees table. So one employee can be the group leader in many projects. The relation is between Projects.GroupLeader field and Employees.ID field
In the Products table i'm trying to add a new column to show the name of the group leader using this

Group leader = RELATED(Employees[Name]) but this does not works. In fact the intellisense of RELATED does not shows me the Employees table.

Any idea please?

regards

1 ACCEPTED SOLUTION

Accepted Solutions
FarhanAhmed1984 Regular Visitor
Regular Visitor

Re: RELATED Function does not shows me the related tables

By the look of it, it seems disabled.


Kindly check what kind of error you are getting when you trying to active it ? Double click on relationship and below will appear

Active Relationship.png

View solution in original post

14 REPLIES 14
FarhanAhmed1984 Regular Visitor
Regular Visitor

Re: RELATED Function does not shows me the related tables

That means there is no relationship between those tables. Kindly check if relationship exists or not?

 

Relationship table.png

 

If there is no relationship create one between Employees and Project by clicking Manage Relationship from Home TabCreate Relationship.png

kintela Member
Member

Re: RELATED Function does not shows me the related tables

captura.jpg

 

This is my relationship

FarhanAhmed1984 Regular Visitor
Regular Visitor

Re: RELATED Function does not shows me the related tables

By the look of it, it seems disabled.


Kindly check what kind of error you are getting when you trying to active it ? Double click on relationship and below will appear

Active Relationship.png

View solution in original post

kintela Member
Member

Re: RELATED Function does not shows me the related tables

Sorry but I don´t understand why in this case that I have this relationships

captura.jpg

When I try to create a new column in "Proyectos" when I use RELATED(... I don't see the table "Contratos".

 

regards

hxkresl Member
Member

Re: RELATED Function does not shows me the related tables

Kintela, was this solved? I am having same issue.  Intellisense isn't picking up the columns in related tables, even though active relationships exist.

Am trying to complete lesson 6 of Microsoft's AdventureWorks tutorial, by creating a calculated column in Product table that imports column values from Product Subcategory and Product Category.   https://msdn.microsoft.com/en-us/library/hh231703.aspx

Capture.PNGyou can see relationships exist between Product tables

 

 

niasha Regular Visitor
Regular Visitor

Re: RELATED Function does not shows me the related tables

Have same problem with related formula.

Intelisence wont pick up defined active relationship.

gbortz Frequent Visitor
Frequent Visitor

Re: RELATED Function does not shows me the related tables

Hi 

 

I am struggling to get the table tpo work..am working through tutorials , have followed all the tracks on problem lists. Does it not depend on thre direction ie your beginning table where you start the related instruction. I notice it works the one way but not the other ie from the Many to one side.

 

All the connections arer active and ticks are in place so the advice given thereon did not help

gbortz Frequent Visitor
Frequent Visitor

Re: RELATED Function does not shows me the related tables

The related table intellisense is not picking up the tables I set up in the manage relationships screen. It seems the joins are direction dependent, I set up bidirectional links but it does not seem to work. I need 2 links ie to go from a stock table through an InvoiceLines table to An Invoice table. The stock table relates to the Invoice lines table through a Stock Id. The invoice lines table related to the Invoice table via an Invoice ID.  The stock table has the Registration Date of the Car. The Invoice table has the Sales Price. I need the difference between the registration  date and the Invoice Date , I need to do this in IN THE STOCK TABLE ie Weeks In Stock = DATEDIFF([RegistrationDate],RELATED(Invoices[InvoiceDate]),WEEK) and Related wont pick up Invoices table.

 

I did try write an eqation in InvoiceLines ( the middel table) referencencing cols in Stock and cols in Invoice Table (ie tables on either side)  and it works so it seems the join is only in one direction. These equations come direrct out of Adam Aspin's book Pro Power Desktop, so could his equations be wrong ie they wont work... Chapter 9 , page 275 

 

Many Thanks

 

Graham

chrisdorrian Frequent Visitor
Frequent Visitor

Re: RELATED Function does not shows me the related tables

I am having this problem too - the relationship has been created and is active, however the error message says there is no such table or no such relationship.

The intellisense does not pop up with any tables, unlike other DAX functions.

Please help!!!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 457 members 4,545 guests
Please welcome our newest community members: