Multiple FILTERS in aggregateX function?

[General Ledger]

Dear All,

I am trying to use the aggregate function MINX with FILTER within PowerPivot (not in a PivotTable). I need to apply more than one FILTER. Everything I try fails and I cannot find online examples of using more than one FILTER in an aggregateX function. Any help out there?

Filtering on one field works fine.
=MINX ( FILTER ( Table1, Table1 [Field1] = A ), [Field3] )

The follow attempts to filter on more than field result in errors:
=MINX ( FILTER ( Table1, Table1 [Field1] = A ) AND ( Table1, Table1 [Field2] = B ), [Field3] )
=MINX ( FILTER ( Table1, Table1 [Field1] = A ) && ( Table1, Table1 [Field2] = B ), [Field3] )
=MINX ( FILTER ( (Table1, Table1 [Field1] = A) && (Table1, Table1 [Field2] = B) ), [Field3] )

Thanks,

G/L

 

[scottsen]

The FILTER() function takes exactly 2 args, the table and the expression to filter. Try:

FILTER(Table1, Table1[Field1] = A && Table1[Field2] = B) <--- both condition are inside a single FILTER.

 

[General Ledger]

scottsen,

Your solution worked perfectly.

Thanks,

GL