userelationship error

Hi, Anonymous 

According to your dax code , you use the DimSatisfiedLevel[SatisfactionID] to FactPerformanceRating[EnvironmentSatisfaction].

This means when you put the DimSatisfiedLevel[SatisfactionID] as a slicer , it will filter the FactPerformanceRating Table.

But in your visual , you use the Year as a dimension (like a slicer) and it returns the same value every year.

First , this dax adding here , it calcualtes the max of the FactPerformanceRating[EnvironmentSatisfaction] every year just related to the 'Table'[Year] and it will not be filtered by the DimSatisfiedLevel[SatisfactionID].

You need to check if current visual has some filter on this page or you put the right field as a dimension.You can also convert this visual to a table visual to see the actual value have got to explore this issue.

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )

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