Forum Discussion
Tiger2514555
2 years agoHelper III
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 i...
Uzi2019
2 years agoCommunity Champion
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?
- Tiger25145552 years agoHelper III
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"))