Data Model Using reference table to connect

[ABC11]

Hello All,

Below is my data model. when I add business Area or TEMP Analyst to report all row repeting.

Before adding Business area or/and temp analyst

After adding Business are

What I am doing worng?

Please, help 

Thanks

[amitchandak]

@ABC11 , If CMS and Table are in 1-1 relation, better you merge table

[ABC11]

No I can't becuase

CMS- I did as reference query from LEM_Laborview table.

Table- I enter data because those data are not in server.(they were in Excel sheet. ) so I copy and paste in table

[v-shex-msft]

Hi @ABC11,

Perhaps you can try to extract two table field values to merge and create a bridge table with distinct values and link to these table fields. They should help power bi to map and analyze the records without matched keys.

Regards,

Xiaoxin Sheng

[ABC11]

Thanks for your reply,

Sorry for late.

I did bridge for CMS table to remove duplicate.  Any more suggestion?

Please

Thanks