Is it possible to filter on more than one condition?

[Dalton948]

I am having difficulties achieving one aspect with my formula which is adding a second condition on a Filter(All(

TTR(Minutes) = 

VAR _CurrentElement_ID = MAX(sys_journal_field[element_id])

VAR _tbl = FILTER(ALLNOBLANKROW(sys_journal_field, sys_journal_field[Team]),sys_journal_field[element_id]=_CurrentElement_ID || sys_journal_field[Team]="Blue Team")

var _maxDate =MAXX(_tbl,sys_journal_field[sys_created_on])

Var _sysID = MAX(Incident[sys_id])

Var _tblb = FILTER(ALL(Incident),Incident[sys_id]=_sysID)

Var _resolvedDate = MINX(_tblb,Incident[resolved_at])

Return

DATEDIFF(_maxDate,_resolvedDate,Minute)
 ------------------------------------------------------------------------------------------------------------------------------------------
In the above formula, I am needing the _tbl Variable to match on the specific element ID and also match the specific team name to filter out alot of unwanted data. It seems that multiple conditions are not allowed in this format. Are there any work arounds or suggestions available?

[Dalton948 · Accepted solution]

Changing 

VAR _tbl = FILTER(ALL(sys_journal_field),sys_journal_field[element_id]=_CurrentElement_ID && sys_journal_field[Team]="Blue Team")

Was the solution

[Dalton948]

This has been solved.