@CarlHRVA Thank you for clarifying! I certainly was misunderstanding you there. Try this instead:
Distinct(
Filter(
'Document Library',
Region = Dropdown5.Selected.Result,
'What Dropdown1_1 Filters' = Dropdown1_1.Selected.Result || IsBlank(Dropdown!_1.Selected.Result),
'Organizational Model'.Value = Dropdown3_1.Selected.Result || IsBlank(Dropdown3_1.Selected.Result)
)
),
Operating_Text
)
The 'What Dropdown1_1 Filters' is there because I wasn't sure what it was. Earlier in the thread, you had a Tower.Value associated with Dropdown1_1, so that might be it.
To explain this a bit, in the Filter function, multiple filter conditions (separated by commas after the data source) act like they are joined by an And (&& when used symbolically). I added some Or statements (the || symbol) in there means as well. You might know this already but for those who come upon this thread in the future, for And statements, all conditions must be true or the result is false. For Or statements, only one condition must be true; only if all conditions are false will it return false. So in this filter, we have three statements that must be true:
- A value must be selected for Dropdown5 that can be found in the Region field
- Either a selected value for Dropdown1_1 can be found in the (assumed) Tower field or Dropdown1_1 has nothing selected
- Either a selected value for Dropdown3_1 can be found in the Operational Model field or Dropdown3_1 has nothing selected
Essentially, we have created a condition that accounts for values or no values being selected in Dropdown1_1 and Dropdown3_1.
Let me know if that does what you need! If not, we'll keep at it!
