Application Optimization help

[arusanah]

Count({$<[Disenrolled Indicator]={'Y'}>}distinct([Recipient Identifier]))

or

If(Disenrolled Indicator]='Y', Count([Recipient Identifier]))

Which one of these expressions is better to use ?

[sunny_talwar · Accepted solution]

Depends on where you are using it. But generally speaking, Set Analysis is more efficient compared to using if statement.

[alexandros17]

Absolutely the first one, infact set analysis optimize execution.

I'm not sure that the second returns correct values...

[arusanah]

I'm using it in Dashboards