Expression going to zero

[nickmarlborough]

i have a table - i only want to include where the 'Team' field contains 'GB' - at the moment i do:

=[Team] like '*GB*'

and the values go to 0 and -1

what is the correct way of doing this

[Brian_C]

Not too sure if this is the answer you are looking for but if you wanted to sum a value where the Team equals GB then using set analysis you could try Sum({<Team={'GB'}>}[Value Field]) and this will sum your value field for Team GB only. If I have misunderstood your requirement please provide a little more detail and will try to assist.

Kindest regards

Brian

[nickmarlborough]

it shouldnt be a sum. 

It should be considered a simple filter on the column to only filter in those with GB and exclude other strings

[Brian_C]

OK. In that case you could create a calculated dimension such as If(Match(Team,'GB'),Team) and this will only display the one Team. Hope this helps.