Hello everyone,
Good day!
I would like to ask what is the best way to avoid delegation using my filter below.
The first filter I used. But i'm having delegation the blue one.
Sort(
Distinct(
Filter(
'Service Region Market',
!(Vendor)
),
Service.Value
),
"Result"
)
Next one is same with first.
Sort(
Distinct(
Filter(
'Service Region Market',
!IsBlank(Vendor)
),
Service.Value
),
"Result"
)
Last is: Having incompatible comparison
Sort(
Distinct(
Filter(
'Service Region Market',
Vendor <> Blank()
),
Service.Value
),
"Result"
)
Thanks in advance for your help. guys!