filtered multiple fields in expression

[James255]

Hi, 

I'm looking to filter two sets of fields in a pie chart.

1.Assembly/Component/SMD - Only to show Assembly

2. Assembler - Only to show Carol

I want both of these to measure the 'Units' field. I've tried the below but doesn't seem to be working as expected.

=If(match([Assembly/Component/SMD],'Assembly')
=If(match([Assembler],'Carol')

[Chanty4u · Accepted solution]

try this

=If(match([Assembly/Component/SMD],'Assembly') and match([Assembler],'Carol'),'Asmbly','Carol')

[James255]

Hi - thanks that does seem to be working. I'd like to filter the count as well. Below doesn't seem to be working as expected.

=Count( {<[Unit] = {"=[Unit] <> 'Carol'"} >}[Unit])

[Chanty4u]

May be this

=Count( {<[Unit]- = {'Carol'} >}[Unit])