Forum Discussion

Tiger2514555's avatar
Tiger2514555
Helper III
2 years ago

Table display incorrect data.

 


From the picture, it shows 3 rows of data, but the correct row is the row with the Day LT Measure value. But when I remove Status or AVG TIME/PRF, it shows the correct data. AVG TIME/PRF is another table that connects each other. I'm not sure if it's something wrong with AVG TIME/PRF or Status.

Need Help
Tutorial Requests

2 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi Tiger2514555 
    You have to check your relationship and whether your calculation is based on other table?
    If yes then you have to add your AVG column in your calculation.

    Or if you can provide the sample data of your model. and how your measure works?

     

    • Tiger2514555's avatar
      Tiger2514555
      Helper III
      2 years ago

      This is my relationship table.

      Day LT Measure =
      SUMX('All PRF', 'All PRF'[Day] - RELATED('STD LT'[AVG TIME/PRF]))

      Status Achieve = IF([Day LT Measure] >= 1,"Not Achieve",IF([Day LT Measure] <=0,"Achieve"))