Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
THENNA_41
Post Partisan
Post Partisan

There are ambiguous between 'template' and Cat Group

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.

 

 

 

THENNA_41_0-1658823334136.png

 

please any one help me  resolve this issues . 

 

thanks in advance ..

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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

1.png

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.

View solution in original post

3 REPLIES 3
THENNA_41
Post Partisan
Post Partisan

@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
 
THENNA_41_0-1658832491773.png

 

 

 

Hi @THENNA_41 
Please clarify further. Tank you.

tamerj1
Super User
Super User

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

1.png

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors