Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

userelationship error

EnvironmentSatisfaction =     CALCULATE(     MAX(FactPerformanceRating[EnvironmentSatisfaction]),     USERELATIONSHIP(DimSatisfiedLevel[SatisfactionID],FactPerformanceRating[EnvironmentSatisfact...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It doesn't seem to be working. 

    Kindly check this link, this is the project and tell me if there is any thing I could do about this error.

    Thanks in advance

    HR_ANALYTICS_PROJECT.pbix

    • v-yueyunzh-msft's avatar
      v-yueyunzh-msft
      Community Support
      3 years ago

      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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        I got it. Thank you very much for your support!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    dataset

    Datasets