@WarrenBelz
Sorry, was halfway through typing a response then saw that you had replied ... thought I'd reply anyway lol
@Satya121
As Warren says, these functions cannot be delegated to SharePoint. Another way around this is to use filtering. If, for example, your list has a column that stores data where filtering on this field will always return less than 2000 items, then you can do something like this.
Assume your field is called 'Region' and is of type Text:
With(
{
// note, each filter must return <2000 records for this method to work
wRegion1: Filter(ashish_5011, Region = "Region1"),
wRegion2: Filter(ashish_5011, Region = "Region2"),
wRegion3: Filter(ashish_5011, Region = "Region3")
},
Sum( wRegion1, 'Number of units') + Sum( wRegion2, 'Number of units') + Sum( wRegion3, 'Number of units') & "
Total Assets"
)
