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!
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!
Nice! Glad you were able to figure it out and thank you for letting me know you got it solved.