HI @
,
I think I got your requirement, it should be like cascading dropdowns (i.e if combobox1 is selected then results in combobox2 and combobox3 should be showing filtered data, if combobox2 is selected then combobox3 should only show data from double filtered data (combobox1+combobox2)).
just to be sure, do you want reverse filters like if combobox3 is selected then filter the combobox2 and combobox1.
based on that I can give you an answer.
and i am assuming you are seeing data in table or gallery control and these filters should also there right.?
if my above statement is correct then
(All the codes are freely typed, syntax issues might be there)
this is for One - Way cascading:
Combobox1 Items:
Distinct('Voortgang en Productie Northstar',Project.Value)
Combobox2 items:
Distinct(
Filter(
'Voortgang en Productie Northstar';
(CountRows(ddProject.SelectedItems)=0 || Project.Value in ddProject.SelectedItems.Value)
),'Weeknummer Productie'
)
Combobox3 Items:
Distinct(
Filter(
'Voortgang en Productie Northstar';
(CountRows(ddProductieweek.SelectedItems)=0 || 'Weeknummer Productie' in ddProductieweek.SelectedItems);
(CountRows(ddProject.SelectedItems)=0 || Project.Value in ddProject.SelectedItems.Value)
),Aannemer.Value
)
And finally in Gallery or Table Control Items:
Filter(
'Voortgang en Productie Northstar';
(CountRows(ddProductieweek.SelectedItems)=0 || 'Weeknummer Productie' in ddProductieweek.SelectedItems);
(CountRows(ddAannemer.SelectedItems)=0 || Aannemer.Value in ddAannemer.SelectedItems);
(CountRows(ddProject.SelectedItems)=0 || Project.Value in ddProject.SelectedItems.Value)
)
if you need to do reverse cascading comboboxs:
then set all combobox1,combox2,combobox3 items property to
Distinct(
Filter(
'Voortgang en Productie Northstar';
(CountRows(ddProductieweek.SelectedItems)=0 || 'Weeknummer Productie' in ddProductieweek.SelectedItems);
(CountRows(ddAannemer.SelectedItems)=0 || Aannemer.Value in ddAannemer.SelectedItems);
(CountRows(ddProject.SelectedItems)=0 || Project.Value in ddProject.SelectedItems.Value)
),column_Name //Make sure to change this to respective column
)
and items property for gallery or table control (keep same as above):
Filter(
'Voortgang en Productie Northstar';
(CountRows(ddProductieweek.SelectedItems)=0 || 'Weeknummer Productie' in ddProductieweek.SelectedItems);
(CountRows(ddAannemer.SelectedItems)=0 || Aannemer.Value in ddAannemer.SelectedItems);
(CountRows(ddProject.SelectedItems)=0 || Project.Value in ddProject.SelectedItems.Value)
)
Please give the mentioned solution a try and let me know whether it works for you.
If it solves your issue, feel free to mark this thread as answered.
Please make sure to like the response!
Thanks!
- Hemanth Sai
