Measure, filter

[Luis_Pena]

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]

@amitchandak thank you, I made a join between boxes and productivity bidirectional and it worked. 👍

[amitchandak · Accepted solution]

@Luis_Pena , Make join between boxes and productivity bidirectional

or try like

Productivity ImagesP = DIVIDE(SUMX('Productivity5', related('Boxes4'[PRODUCTION])), SUM('Productivity5'[Time]))