How to do IF statement in a measure

[Anonymous]

Hello

I have a table 'fact_kpi'.  The values in this table are 'Investment GBP' and the account codes are 'groupcoa and I also have another value that I filter on called 'moves'  .  I neeed to filter the Investment GBP values based on account code  =  1* accounts and moves code = 'BFD'  Can you give any advice on how to do this 

Many thanks

Paul

FYI - in Qlikview I would have done the below (altho I had to filter by period in qlikview also)

sum({< groupcoa = {'1*'}, period = {"=$(vStartPeriod)"}, moves = {'BFD'}>}[Investment GBP])*-1

[Greg_Deckler]

@Anonymous Maybe:

Measure = 
  VAR __Table = FILTER('Table', [moves] = "BFD" && LEFT([Investment GBP],1) = "1")
  VAR __Result = SUMX(__Table, [Some Column])
RETURN
  __Result