Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.