Related function does not show me the tables I created relationships for

[wsspglobal]

Hi All,

I have trouble using the RELATED function. I have two tables that have an active relationship created. It is a many-to-one relationship. I need to pull data from Table A (one), to Table B (many). But I can only use RELATED in Table B to call out Table A, not the other way round. Can someone help?

[V-pazhen-msft]

@wsspglobal 

Have you solved your problem? If yes please mark the solutions that helped you. If not, please reply the posts if needed.

Paul Zheng 

Best Regards

[V-pazhen-msft]

@wsspglobal 

You can only use RELATEDTABLE in Table A to call out Table B. 

Related() goes from the Many side of a relationship to the One side of a relationship. 

RELATEDTABLE() goes from the One side of a relationship to the many side.

Please Refer to: https://theexcelclub.com/dax-power-pivot-power-bi-ssas-related-and-relatedtable/

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

[Ashish_Mathur]

Hi,

Your statements are inconsistent - You first say "I need to pull data from Table A (one), to Table B (many)" and then you say "But I can only use RELATED in Table B to call out Table A, not the other way round".  If Table A is the one side and there is an active relationship, then the RELATED() function should work very well in Table B.  You need to share data and show the expected result.