Forum Discussion
Relationships
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.
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