Table display incorrect data.

[Tiger2514555]

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.

[Uzi2019]

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]

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