Forum Discussion

illmatic's avatar
illmatic
Frequent Visitor
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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])

 

 

 

 

  • illmatic's avatar
    illmatic
    Frequent Visitor
    5 years ago

    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.

  • illmatic's avatar
    illmatic
    Frequent Visitor
    5 years ago

    Adding the filter gives me an error, but the first portion of this works.  I'm assuming you are filtering based on the Project ID so it only averages for that specific projectID, however, this throws the error:  "cannot convert value of [ProjectID] of type text to true/false."