There are ambiguous between 'template' and Cat Group

[Anonymous]

I am trying to create Realtionshiop   Vendor code [Vendor code ] to FINAL[Vendor code]  but i am getting ambiguous between Error.

My PBIX File link :  Power BI File  

I added screen shot below for reference.

please any one help me  resolve this issues . 

thanks in advance ..

[Anonymous]

@tamerj1  thank you so much .. its working Now. i have one more doubt . in this report i am using Matrix visual so there is no option for Number format  to change MIillion . i used below measure 

Temp val = FORMAT(SUM(template[Quantity]), "#,,.0M")

I applied above measure in to matrix visual . i am getting   like below  adde screen shot . but it is wokring when i use  input source column Quanity

[tamerj1]

Hi @Anonymous 
Please clarify further. Tank you.

[tamerj1 · Accepted solution]

Hi @Anonymous 
Here is the file with the relationship created. https://we.tl/t-Vax6OoGOJF

Still there is a clear problem in the model that requires further assessment. For some reason the engine is unable to create one to many relationship! which is strange.