Hi
Im trying to filter value to be displayed in a dropdown box.
I want to filter from a SharePoint list and this works fine.
Distinct(Filter(AssetListData;Title=ItemData.SelectedText.Value);Vendor)
Example above i filter from list displays Vendors based on Title
Now i want to Filter Model based on Vendor and Title.
Currently my filter for the Model field looks like this.
Distinct(Filter(AssetListData;Vendor=VendorData.SelectedText.Value);Model)
With the above i will get all results that matches the Vendor but i want it to distinct not only vendor but also Title.
If the a Vendor for example Microsoft has 500 models then all is showend. But i want to filter like this.
If Title is = TV and Vendor is Microsoft show only models that are TV and Vendor Microsoft.
