Thanks for the suggestion, I tried adding the IsEmpty() to the formula but it still functions the same. It functions perfectly if I click the "Clear" button I set up, but if you click the x in the combo box it breaks
Here's the code:
If(
//If Agent filter is Blank
Or(IsBlank(AgentInput_1), IsEmpty(AgentInput_1)),
//Then check if month input is blank and if so show all items
If(
Or(IsBlank(MonthInput), IsEmpty(MonthInput)),
Sort(
Distinct(
_EvaluatorRecords,
Date(
Year('Session Date'),
Month('Session Date'),
1
)
),
Result,
Descending
),
//Else, filter the results by the Month filter
Sort(
Filter(
Distinct(
_EvaluatorRecords,
Date(
Year('Session Date'),
Month('Session Date'),
1
)
),
Result = MonthInput.Selected.Value
),
Result,
Descending
)
),
//Else agent filter is not blank, check if month input is blank
If(
Or(IsBlank(MonthInput), IsEmpty(MonthInput)),
//If month filter is blank, filter by only agent filter
Sort(
Distinct(
Filter(
_EvaluatorRecords,
AgentInput_1.Selected.Result in Agent.Email
),
Date(
Year('Session Date'),
Month('Session Date'),
1
)
),
Result,
Descending
),
//Else, filter by both Month filter and Agent Filter
Sort(
Filter(
Distinct(
Filter(
_EvaluatorRecords,
AgentInput_1.Selected.Result in Agent.Email
),
Date(
Year('Session Date'),
Month('Session Date'),
1
)
),
Result = MonthInput.Selected.Value
),
Result,
Descending
)
)
)
