Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measures are showing all data without filtering

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...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

Thank you!!