userelationship error

Hi, Anonymous 

Thanks for your quick response and you .pbix file .

I download it and see the dax now you used , i think this return the right.

You put the 'DimDate'[Year] on the visual  and use the MAX(FactPerformanceRating[JobSatisfaction]) to get the max of the JobSatisfaction per year.

And in your sample data , it seems to the max of the JobSatisfaction is the same in the each year . And it equals 5:(Such as : in 2013 year ,  the max of the JobSatisfaction =5 ;in 2014 year ,  the max of the JobSatisfaction =5)

Just in the other filter context , it will return the different value .

So the value it returns is the right logic , you need to check what the really result you need . 

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