Measures are showing all data without filtering

[Anonymous]

Hi. Please look at the last column (LOSS wrt MED TRIP IN).


My expected output is that this table will only show PAC=PTTEP because for year 2021, only PTTEP has a value of LOSS wrt MED TRIP IN. I don't know why my table is showing the value for all PAC. Even though the value of LOSS wrt MED TRIP IN in PAC other than PTTEP is 0, it is still wrong because still showing other PAC. 

This is my measure. 

LOSS wrt MED (TRIP IN) = (SUMX(ODBS_FTO_BHA,DIVIDE(ODBS_FTO_BHA[Minus MED TRIP IN],24,0)*(ODBS_FTO_BHA[RIG_COST]*1000))) + 0

 

Btw this is the filter that I'm using for this page 

Where can I change so that I will only show the data for selected year?

[amitchandak · Accepted solution]

@Anonymous , +0 force left join. remove that and try

LOSS wrt MED (TRIP IN) = (SUMX(ODBS_FTO_BHA,DIVIDE(ODBS_FTO_BHA[Minus MED TRIP IN],24,0)*(ODBS_FTO_BHA[RIG_COST]*1000)))

[Anonymous]

Thank you!!