Hi,
Could you please share your collection for a better understanding?
You can try using this code for a while.
Distinct(
Filter(
Choices('[@Bid Process'].Client_Sector),
Value in Filter(Client_Sector, DataCardValue9.Selected.Value = Country_of_client.Value.Title).Value
)
)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,532 Super User 2024 Season 2
Martin Dráb 228,501 Most Valuable Professional
nmaenpaa 101,148