Create Calculate column in Live Connection or Alternate measure

[Arioli_Chezhian]

Hello All,

I have 2 tables, Table 1 is live connection(Using existing dataset) and Table 2 is import file. The Employee ID present in import file should be shown as "Flag - Internal", and for other records should be shown as "External" or "Blank". 

We have to bring that Flag column from table 2 to table 1. Using RELATED function we can achieve this but since Table 1 is live connection unable to create Calculate column and Calculate Table.
Using relationship between these 2 table if we directly drag and drop the Flag column in a table visual, data will filtered out where Flag = Internal. Flag = External won'tbe appeared in the visual.  I believe it should be handled in Measure. 

Please advice how to achieve this measure. 

[amitchandak · Accepted solution]

@Arioli_Chezhian , Try a measure like

coalesce(maxx(filter(Table2, Tabel2[Emp ID] = Max(Table1[EMP ID])) , Table2[flag]), "External")