expression to exclude and include in chart

[everest226]

Delta code value is 001,002,003,004

Source field Value is   AAA,BBB,CCC

Sum({<[Delta Code]={'0*'},[Departure Year]={"$(=Max([Departure Year]))"}>}[People])

how to edit this expression ,

if source Field is AAA then use 002 for no of people otherwise use all delta code 

thansk 

[zoltann14]

Hi,
Try something like this:
Pick(Match([Your Source field],'AAA')+1,Sum({<[Delta Code]={'0*'},[Departure Year]={"$(=Max([Departure Year]))"}>}[People]),
Sum({<[Delta Code]={'002'},[Departure Year]={"$(=Max([Departure Year]))"}>}[People]))

[Vegar · Accepted solution]

You could use an if statement.
If (Field='AAA',
Sum({<[Delta Code]={'002'},[Departure Year]={"$(=Max([Departure Year]))"}>}[People]),
Sum({<[Delta Code]={'0*'},[Departure Year]={"$(=Max([Departure Year]))"}>}[People])
)

[everest226]

Thanks