Hi @GandT
You may need to replace DataTable1 in your formula with the actual Items property of the datatable itself. I found by experimentation, that if you use a gallery instead of a datatable, that your formula works but it requires Gallery1.AllItems, something that is not available in a datatable. In the screenshot, the average works for the gallery but not the datatable. However, if I replace DataTable2 in the formula with
Average(
Filter(
sales, Country=Dropdown2.Selected.Result),'Units Sold'
)
)
, then it works fine. FYI, you can design a gallery to look identical to a datatable and it is a much more flexible control.
