Forum Discussion
Domenick
Helper IV
Helper IVRelated Function Not Working
I'm trying to bring a value from a related table, but the RELATED function keeps erroring on me. My syntax is: P_PhaseName = RELATED(PIM_Project_Phases[Name]) and here's my relationshi...
In you case, try use RELATEDTABLE in Table A to call out Table B.
Related() is used to refer to One side of a relationship.
RELATEDTABLE() refer 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.
Greg_Deckler
Community Champion
Community ChampionWell, many-to-many tends to be tricky, would recommend a bridge table. Also, RELATED is most likely bringing back multiple records so you might want to wrap it in an aggregation like MAXX or MINX. You might want to experiment with RELATEDTABLE.