Exclude a product line from measure equation

[Anonymous]

Hello and Happy New Year!!!

I am attempting to exclude a certain product line in a capital KPI chart.

The measure is: sum([capital])

So I attempted with this formula.

If([Business Segment]='Fruits', not Match([Product Line],
'Grapes'), [Product Line]

and

sum([Capital]))

What I am trying to do is say, when I am selected on Fruits, I want to exclude grapes (is a product line) from the KPI capital number.

Currently, I am getting a dash with the above equation.

Thanks in advance for your help!!!!

[Anonymous]

Shoot not working on the including piece. I can keep playing with it. It is just displaying as if it is not included so far.

[sunny_talwar]

How about this

If(GetFieldSelection([Business Segment]) = 'Nuts', Sum({<[Product Line] = {'Apples'}, [Business Segment]>}[capital]) + Sum(capital), Sum(capital))

[Anonymous]

I will try this out when I get a chance. As always, thank you so much for your help Sunny.

[sunny_talwar]

No problem at all