topic Re: expression to exclude and include in chart in App Development

expression to exclude and include in chart

everest226 — Sat, 16 Nov 2024 07:15:35 GMT

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

Re: expression to exclude and include in chart

zoltann14 — Mon, 19 Nov 2018 22:38:21 GMT

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

Re: expression to exclude and include in chart

Vegar — Mon, 19 Nov 2018 22:42:26 GMT

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

Re: expression to exclude and include in chart

everest226 — Mon, 19 Nov 2018 23:05:32 GMT

Thanks