Forum Discussion
Solved
Measure, filter
Hello, I have the colunm PRODUCTION, and according it I measure the productivity
Productivity ImagesP = DIVIDE(SUM('Boxes4'[PRODUCTION]), SUM('Productivity5'[Time]))
but when I apply a filter in the table the column PRODUCTION doesn't update the total value only for the user, it keeps its value for all users, so the productiviy for that especific user is not right.
this is the table
And this is the relations
any help, thank you
Luis_Pena , Make join between boxes and productivity bidirectional
or try like
Productivity ImagesP = DIVIDE(SUMX('Productivity5', related('Boxes4'[PRODUCTION])), SUM('Productivity5'[Time]))
2 Replies
Luis_Pena , Make join between boxes and productivity bidirectional
or try like
Productivity ImagesP = DIVIDE(SUMX('Productivity5', related('Boxes4'[PRODUCTION])), SUM('Productivity5'[Time]))
amitchandak thank you, I made a join between boxes and productivity bidirectional and it worked. 👍
