Hi,
I'm running this simple code
AddColumns(
GroupBy(
Filter(
Systems_Users,
Module = ComboBox1_6.Selected.Module_Name
),
"Module",
"Data"
)As ActualUsers,
"QTYs",
Sum(
ActualUsers[@Data],
QTY
)
)
Where the user select a Module name then the app calculates the number of the quantities for that module.
The Systems_Users is a SharePoint list with +2k records, and some modules have more than 2k records.
However, the maximum number of QTYs I get for a selected module is 2000
I know both functions Filter & Sum are delegable, and I don't get any delegation warning, so what's the issue?
Thanks,

Report
All responses (
Answers (