Forum Discussion
Relationships on Multiple Calculated Columns - Calculated Table Solution Help
jdbuchanan71 Had a bit of a revelation and realised the solution was quite simple. I was returning the ID value then trying to create a relationship on that ID.
I've changed the calculated columns to return the actual name of hte assessor or employer (which is the information I want to visually display) and removed the relationships and now this works perfectly.
Thanks for your help though!
Hello paulalmond91
It is hard to advise without seeing the uniqueness and fileds of the actual tables. Could you possibley share your .pbix file by uploading it to OneDrive or DropBox and sharing the link?
Thanks for helping here.
Here is a pbix file with the desired outcomes and the relationships in place for what I want to achieve.
https://www.dropbox.com/s/qvkulv25exgv0fj/Testing.pbix?dl=0
I haven't included my full file as its huge and contains some confidential info etc.
Basically, the values you see in ActEmployerID and ActAssessorID are the correct result of the calculated column expressions included in the original post and are working as expected its just I cant create more than one relationship from a calculated column on the Activities table and I need both to have a relationship as it is in the pbix file. Currently I have to choose either assessor or employer.
Does this help?
Your sample file doesn't align with the calculated columns formulas you listed. I'm assuming the tables names
are
Assessors = Assigned Assessors
Employers = Assigned Employers
But you list several fields in your calculated columns formula that are not in the Assessors table
ActAssessorID =
CALCULATE (
MAX ( 'Assigned Assessors'[Assessor ID] ),
FILTER (
'Assigned Assessors',
AND (
'Assigned Assessors'[Active Assessor] = TRUE (),
'Assigned Assessors'[Trainee ID] = 'Activities'[Trainee ID]
)
)
)jdbuchanan71 Had a bit of a revelation and realised the solution was quite simple. I was returning the ID value then trying to create a relationship on that ID.
I've changed the calculated columns to return the actual name of hte assessor or employer (which is the information I want to visually display) and removed the relationships and now this works perfectly.
Thanks for your help though!