Hi,
I think I have implemented something similar with your request.
In my case I had a scnerio of Branch, Area, Region - Area being filtered based on Region selected and Branch being filtered based on Area and Region selected.
So my first drop down "Region" has the following function:
SortByColumns(Distinct(BranchAreaRegion, Region), "Result")
- which returns all the distinct values from the Region column from my list
The second one "Area" has the following function:
SortByColumns(Distinct(Filter(BranchAreaRegion, Region = [@ddRegion].Selected.Result).Area, Area), "Result")
- which is based on the selection from the "Region" drop down
And the final one "Branch" has the following function:
SortByColumns(Filter(BranchAreaRegion, Region = [@ddRegion].Selected.Result && Area = [@ddArea].Selected.Result), "Branch").BranchRef1
- which is based on both the previous selections
Hope this helps 🙂
