topic Re: Relationship in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Relationship/m-p/857410#M2773 <P>Hi,</P><P>&nbsp;</P><P>It looks like that this question is regarding modeling so, you&nbsp;should ask it in an&nbsp;<A href="https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer" target="_self">appropriate thread</A>.</P><P>&nbsp;</P><P>Kind Regards,</P><P>&nbsp;</P><P>Evgenii Elkin,<BR />Software Engineer<BR />Microsoft Power BI Custom Visuals<BR />pbicvsupport@microsoft.com</P> Tue, 26 Nov 2019 15:37:53 GMT v-evelk 2019-11-26T15:37:53Z Relationship https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Relationship/m-p/853073#M2766 <P>Hi,</P><P>I have two table 1st consist of ISD number and in 2nd table I have range and country name.</P><P>From 1st table I took 1st 8 digit of ISD number. Now I want to find this 8 digit number follow in which country from my 2nd table. But there is no common column or any criteria in these two table, so I have added one more column in my 2nd table&nbsp; &nbsp;as ISD to make relation in two table still give me error. Please see the below error&nbsp;</P><P>My Formula is :&nbsp;</P><DIV><DIV><FONT color="#FF6600"><SPAN>country = IF('Hyd Dec CDR 2018 '[Call Type]="ISD",IF(AND('Hyd Dec CDR 2018 '[ISD Type]&gt;=RELATED(Sheet1[End Area Code2]),RELATED(Sheet1[End Area Code2])),RELATED(Sheet1[Country]),'Hyd Dec CDR 2018 '[Call Type]))</SPAN></FONT></DIV><DIV><SPAN>Error</SPAN></DIV><DIV><FONT color="#993300"><SPAN>The column 'Sheet1[Country]' either doesn't exist or doesn't have a relationship to any table available in the current context.</SPAN></FONT></DIV></DIV><P>&nbsp;</P><P>1st Table&nbsp; &nbsp; (<SPAN>Hyd Dec CDR 2018)</SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2nd table (<SPAN>(Sheet1)</SPAN></P><TABLE><TBODY><TR><TD>finalCalledPartyNumber</TD><TD>Call Type</TD><TD>ISD Type</TD><TD>ISD Type</TD><TD>&nbsp;</TD><TD>Country</TD><TD>Start Area Code</TD><TD>End Area Code</TD><TD>Call Type</TD></TR><TR><TD>0018043000</TD><TD>ISD</TD><TD>00180430</TD><TD>00180430</TD><TD>&nbsp;</TD><TD>US &amp; Canada [Toll-free - 001844]</TD><TD>00184400</TD><TD>00184499</TD><TD>ISD</TD></TR><TR><TD>00440140771</TD><TD>ISD</TD><TD>00440140</TD><TD>00440140</TD><TD>&nbsp;</TD><TD>US &amp; Canada [ISD]</TD><TD>00188900</TD><TD>00188999</TD><TD>ISD</TD></TR><TR><TD>0044012682</TD><TD>ISD</TD><TD>00440126</TD><TD>00440126</TD><TD>&nbsp;</TD><TD>US &amp; Canada [ISD]</TD><TD>00187800</TD><TD>00187899</TD><TD>ISD</TD></TR><TR><TD>00440140771</TD><TD>ISD</TD><TD>00440140</TD><TD>00440140</TD><TD>&nbsp;</TD><TD>US &amp; Canada [ISD]</TD><TD>00186700</TD><TD>00186700</TD><TD>ISD</TD></TR><TR><TD>0018004428</TD><TD>ISD</TD><TD>00180044</TD><TD>00180044</TD><TD>&nbsp;</TD><TD>US &amp; Canada [ISD]</TD><TD>00185600</TD><TD>00185699</TD><TD>ISD</TD></TR><TR><TD>0018004428</TD><TD>ISD</TD><TD>00180044</TD><TD>00180044</TD><TD>&nbsp;</TD><TD>US &amp; Canada [ISD]</TD><TD>00184500</TD><TD>00184599</TD><TD>ISD</TD></TR><TR><TD>0018004428</TD><TD>ISD</TD><TD>00180044</TD><TD>00180044</TD><TD>&nbsp;</TD><TD>US &amp; Canada [ISD]</TD><TD>00180100</TD><TD>00180199</TD><TD>ISD</TD></TR><TR><TD>0018004428</TD><TD>ISD</TD><TD>00180044</TD><TD>00180044</TD><TD>&nbsp;</TD><TD>US &amp; Canada [ISD]</TD><TD>00180000</TD><TD>00180099</TD><TD>ISD</TD></TR><TR><TD>0018004428</TD><TD>ISD</TD><TD>00180044</TD><TD>00180044</TD><TD>&nbsp;</TD><TD>UK</TD><TD>00440000</TD><TD>00449999</TD><TD>ISD</TD></TR><TR><TD>0018004428</TD><TD>ISD</TD><TD>00180044</TD><TD>00180044</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>00440140325</TD><TD>ISD</TD><TD>00440140</TD><TD>00440140</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P><SPAN>Please help,</SPAN></P><P>&nbsp;</P><P><SPAN>Regards,</SPAN></P><P><SPAN>Sandeep Joshi</SPAN></P> Fri, 22 Nov 2019 10:52:03 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Relationship/m-p/853073#M2766 TestBI 2019-11-22T10:52:03Z Re: Relationship https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Relationship/m-p/857410#M2773 <P>Hi,</P><P>&nbsp;</P><P>It looks like that this question is regarding modeling so, you&nbsp;should ask it in an&nbsp;<A href="https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer" target="_self">appropriate thread</A>.</P><P>&nbsp;</P><P>Kind Regards,</P><P>&nbsp;</P><P>Evgenii Elkin,<BR />Software Engineer<BR />Microsoft Power BI Custom Visuals<BR />pbicvsupport@microsoft.com</P> Tue, 26 Nov 2019 15:37:53 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Relationship/m-p/857410#M2773 v-evelk 2019-11-26T15:37:53Z