https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Relationship-within-Measure/m-p/1307665#M22741 Hm... I might be able to help you if I could understand what you've written here... But I can't. Sorry. Wed, 19 Aug 2020 13:47:20 GMT Anonymous 2020-08-19T13:47:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Relationship-within-Measure/m-p/1304929#M22654 <P>Hello everyone!</P><P>I need to create a relationship between two tables within a dax measure.</P><P>I have the following both tables:</P><P>tblOrder</P><TABLE border="1"><TBODY><TR><TD>OrderNr</TD><TD>Date</TD><TD>Value</TD></TR><TR><TD>1</TD><TD>01.01.2020</TD><TD>5000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>tblLedger</P><TABLE border="1"><TBODY><TR><TD>OrderNr</TD><TD>Date</TD><TD>Type</TD><TD>Quantity</TD></TR><TR><TD>1</TD><TD>01.01.2020</TD><TD>B</TD><TD>50</TD></TR><TR><TD>1</TD><TD>01.01.2020</TD><TD>T</TD><TD>500</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Unfortuantely, for now it is not possible to link both tables in the data model.</P><P>So there is wheter an active oder inactive relationship.</P><P>Now I would like to display every order in a matrix/ table with two colums.</P><P>The first one for all Types = B</P><P>And the second one for all Types = T</P><P>&nbsp;</P><P>But how?</P> Tue, 18 Aug 2020 17:18:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Relationship-within-Measure/m-p/1304929#M22654 joshua1990 2020-08-18T17:18:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Relationship-within-Measure/m-p/1304951#M22655 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="92006" data-lia-user-login="joshua1990" class="lia-mention lia-mention-user">joshua1990</a> , Not very clear, You can take type on matrix column. Ideally, these two should be joined to common orderNr Dimension </P> Tue, 18 Aug 2020 17:33:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Relationship-within-Measure/m-p/1304951#M22655 amitchandak 2020-08-18T17:33:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Relationship-within-Measure/m-p/1307665#M22741 Hm... I might be able to help you if I could understand what you've written here... But I can't. Sorry. Wed, 19 Aug 2020 13:47:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Relationship-within-Measure/m-p/1307665#M22741 Anonymous 2020-08-19T13:47:20Z