Need assistant

[TestBI]

Hi,

I have two table 1st consist of ISD number and in 2nd table I have range and country name.

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   as ISD to make relation in two table still give me error. Please see the below error 

My Formula is : 

country = IF('Hyd Dec CDR 2018 '[Call Type]="ISD",IF(AND('Hyd Dec CDR 2018 '[ISD Type]>=RELATED(Sheet1[End Area Code2]),RELATED(Sheet1[End Area Code2])),RELATED(Sheet1[Country]),'Hyd Dec CDR 2018 '[Call Type]))

Error

The column 'Sheet1[Country]' either doesn't exist or doesn't have a relationship to any table available in the current context.

1st Table    (Hyd Dec CDR 2018)                                                   2nd table ((Sheet1)

finalCalledPartyNumber	Call Type	ISD Type	ISD Type		Country	Start Area Code	End Area Code	Call Type
0018043000	ISD	00180430	00180430		US & Canada [Toll-free - 001844]	00184400	00184499	ISD
00440140771	ISD	00440140	00440140		US & Canada [ISD]	00188900	00188999	ISD
0044012682	ISD	00440126	00440126		US & Canada [ISD]	00187800	00187899	ISD
00440140771	ISD	00440140	00440140		US & Canada [ISD]	00186700	00186700	ISD
0018004428	ISD	00180044	00180044		US & Canada [ISD]	00185600	00185699	ISD
0018004428	ISD	00180044	00180044		US & Canada [ISD]	00184500	00184599	ISD
0018004428	ISD	00180044	00180044		US & Canada [ISD]	00180100	00180199	ISD
0018004428	ISD	00180044	00180044		US & Canada [ISD]	00180000	00180099	ISD
0018004428	ISD	00180044	00180044		UK	00440000	00449999	ISD
0018004428	ISD	00180044	00180044
00440140325	ISD	00440140	00440140

Please help,

Regards,

Sandeep Joshi

[dax]

Hi TestBI, 

It seems that you don't have relationship between two tables, right? If so , I think you need to create relationships between them, then use measue to see whether it work or not. By the way, if possible, could you please inform me more detailed information(such as your sample data and your expected output)? Then I will help you more correctly.

Best Regards,
Zoe Zhi

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

[parry2k]

@TestBI you cannot use related  function on non-related tables, use lookupvalue function to get value from non related tables.