Relationships

[KMcGhee]

I am currently having an issue with relationships, I have a 1 to many relationship on my tables. I am able to add some columns and not others from these tables to the report I am building. It will join one column and then tell me the relationship doesn’t exist when I want to add another column from the same table. I am under the assumption once the relationship is there it would join the column based on the relationship that has been established (Employee ID) and it is not working like this for me.

[KMcGhee]

Thank you, 

These are my relationships, I am trying to pull in the perfomance metrics estimated Manual rate from the Roster 2 table into my report. I get there is no relationship when trying to do this but I am able to pull in the expected electronic rate with no issue (from the same table).

This is what my report looks like before attempting to pull in the Expected Manual Rate from the Roster 2 table 

This is what I get once I click on Expected Manual Rate from the Roster 2 table. My question is why do I not get this error when I select the expected electronic rate from the same table but get it when I try to load the expected manual rate.

[v-yueyunzh-msft]

Hi , @KMcGhee 

According to your description, when you put the field [Expected Manual Rate] from the Roster 2 table. It returns error code. Right?

You should check this situation:

First, if you place a field with an error, the value of the field you placed cannot be calculated in the current filtering context.This is related to all the fields you previously placed in the table.

You need to check that all the fields you put in front of the table are related to the Roster 2 table.

If there is a field that is not related, you can try removing the field first and then putting in the field you need to test if the field is causing the problem.

If none of the above are true, you can provide the .pbix file of your error (does not contain sensitive data).

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Greg_Deckler]

@KMcGhee Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[KMcGhee]

Thanks none of these anwers helped. I am going to present what I have and sign up for a live training so I can have someone to ask questions in real time.