Calculated column error

[Elyblog2009]

Hello all,

Can please someone help me on the below error? I am new at Power Bi and I am not figuring out where is the issue in the relationship created between the table of the formula itself. 

I have 2 table data Main "Customer Profile" and VFAL_Product_Portfogio"

I need to match the "Product" column in Customer Profile with the Product in the VFAL_Product_List with the Product Portofoglio Name and in the Customer Profile tab the column Service to be populated with the Product Porfoglio Name.

I have created this relationship between tables .

Please I need support.

Thank you!

[Uzi2019]

Hi @Elyblog2009 

2 tables will have only one active relationship. if you want to connect above two tables n try to join from Primary key to foreign key of table . 1 to many relationship. 

1st identify primary key whether your product is primary key or portfolio name then join with second table only with product or portfolio name either of 1 not both.

that's it. your model will be ready to use for futher analysis.

Note: If you have accepted the solution of expert it means your post will not be viewed by other solutioner. you have to again post it so other expert will able to answer it.
you have accepted the solution which has not solved your issue. Foodd has given you options how you can upload the pbix file and how to post the question. please follow the guidlines.

I hope I answered your question!

[Elyblog2009]

Hello all,

Can please someone help me with the below error? I am new at Power BI and I am not figuring out where is the issue in the relationship created between the table of the formula itself. 

I have 2 table data Main "Customer Profile" and VFAL_Product_Portfogio" 

ProductFamily Name

Mobile

APN

FLEET

ProductVFAL_Product_Family Mobile Mobility APN CLOUD FLEET IoT I need to match the "Product" column in Customer Profile with the Product in the VFAL_Product_List with the Product Portofoglio Name and in the Customer Profile tab the column Service to be populated with the Product Porfoglio Name. I have created this relationship between tables .       Please I need support. Thank you!

[Elyblog2009]

This issue is not resolved. Pleased if you can help me?

[Elyblog2009]

Please help me on the error above. Thank you!

[foodd · Accepted solution]

Hello @Elyblog2009, and thank you for sharing a question with the Community.  Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.