Forum Discussion
RELATED function with many:1 relationship
I know this has been asked a lot, but I still can't seem to get pointed in the right direction. I am trying to utilize the RELATED function in DAX to create a calculated column based on the values i...
You should be able to bring the calculated columns into the Project table fairly painlessly for example if you wanted the Average risk Score, create a calculated column in the projects table and input:
Average risk score = CALCULATE(AVERAGE('Risks'[Risk Score]),'Risks'[ProjectId])
I'll try this route as well. I think I was trying to use the RELATED function to bring in a measure from the Risks table and that wasn't working. Thanks for providing an alternate resolution! I think this one may be much simpler and more direct.