Conditional Expression with selected fields

[Anonymous]

Dear folks,

I am trying to calculate an expression. In the listbox Source I have 3 fields: LATAM, EMEA and All.

If I select both LATAM and EMEA, I need to calcule the expression with values from all.

I tried that but did not work:

=
If
(
Source = 'LATAM' and 'EMEA',

Sum ({<Source='All'>}[GM %])
,
Sum([GM %])
)

You guys can help me?

Thx

[tresesco]

Try like:

=If(GetFieldSelections(Source)='EMEA, LATAM',Sum ({<Source='All'>}[GM %]),Sum([GM %]))

[Anonymous]

Thx for the fast response

This expression is returning the value 0.

[tresesco]

Could you share your sample qvw to check?

[Anonymous]

No need.

That worked:

=
If(
GetFieldSelections(Source)='EMEA, LATAM'
,
-(Sum ([GM %]) - Sum({<[Source]=>}[GM %]))
,
Sum([GM %])
)

Thank you anyways