Hi
Hi, i want to make filters like excel.
without circular reference error
there is any idea?
Excel, all the columns are type text
there is a table that i want to show the info following what is choose in filters
Columns: Name, Age, Gender, City.
but when i choose a age or other, the others filters didn't show their info according it, show everything of the columns
So i tried:
for exemple, 4 filters: name, age, gender, city
In items comboBoxName:
Distinct(Filter(dataSource;
AgeCol in comboBoxAge.SelectedItems;
GenderCol in comboBoxGender.SelectedItems;
CityCol in comboBoxCity.SelectedItems
); NameCol)
In items comboBoxAge:
Distinct(Filter(dataSource;
NameCol in comboBoxName.SelectedItems;
GenderCol in comboBoxGender.SelectedItems;
CityCol in comboBoxCity.SelectedItems
); AgeCol)
the same rule for the rest...
then come a error: This rule creates a circular reference between properties which is not allowed. A property cannnot reference itself or other properties affected by its value
Items of the table there is a function Filter for what is in the filters.
