Hi Experts,
I have the below formula to calculate number of tickets based on the selection of various dropdowns, this is limited to 2,000 entries, can you advise how I can calculate the entire sharepoint list without limitations please?
CountRows(
Filter(QualityPortal,
'Business Unit' = 'Dropdown-BusinessUnit_2'.Selected.Value || "Please select an option"=('Dropdown-BusinessUnit_2'.Selected.Value),
Classification = 'Dropdown-Classification_2'.Selected.Value || "Please select an option"=('Dropdown-Classification_2'.Selected.Value),
Status = 'Dropdown-Status_2'.Selected.Value || "Please select an option"=('Dropdown-Status_2'.Selected.Value),
Function ='Dropdown-SourceFunction_2'.Selected.Result || "Please select an option"=('Dropdown-SourceFunction_2'.Selected.Result),
'Cause Category' = 'Dropdown-CauseCategory_2'.Selected.Title || "Please select an option"=('Dropdown-CauseCategory_2'.Selected.Title),
Source = 'Dropdown-Source_2'.Selected.Value || "Please select an option"=('Dropdown-Source_2'.Selected.Value),
'Business Change Required' = 'Dropdown-BusinessChange_2'.Selected.Value || "Please select an option"=('Dropdown-BusinessChange_2'.Selected.Value)
)
)
Thanks in advance!