Very Slow Filter appear

[Sirfyaad]

Hi,

This function is working but 2 condition filtering very slow data can you explain me. why data appear very slow.

FILTER("CAMPUS SCAN SHEET",

IFS([_THISROW].[SELECT TYPES]=BY DATE,
AND([DATE]>=[START DATE],[DATE]<=[END DATE])
,

[_THISROW].[SELECT TYPES]=BY CHANNEL,
[CHANNEL]=[_THISROW].[Select Channel],

[_THISROW].[SELECT TYPES]=COURIER WISE,
[COURIER NAME]=[_THISROW].[Select Courier Name],

[_THISROW].[SELECT TYPES]=BY DATE AND CHANNEL,
AND([DATE]>=[START DATE],[DATE]<=[END DATE],[CHANNEL]=[_THISROW].[Select Channel]),

[_THISROW].[SELECT TYPES]=BY DATE AND COURIER WISE,
AND([DATE]>=[START DATE],[DATE]<=[END DATE],[COURIER NAME]=[_THISROW].[Select Courier Name]),

[_THISROW].[SELECT TYPES]=Default Data,TRUE

)
)

1 condition:-  [_THISROW].[SELECT TYPES]=COURIER WISE,
[COURIER NAME]=[_THISROW].[Select Courier Name],

2 condition:- [_THISROW].[SELECT TYPES]=BY DATE AND COURIER WISE,
AND([DATE]>=[START DATE],[DATE]<=[END DATE],[COURIER NAME]=[_THISROW].[Select Courier Name])