Hi everyone
I want to have ListBox depends on another listbox to filter a DataTable, but the challange here that I want my list box to have all items in it selected (ListBox are always not selected until the user select). So the ListBox should always selected everything in it.
My Formula in Items: Distinct(Filter(Table2, Division = ListBox3.Selected.Result), Department)
How can I proseed?is it doable or not?