If condition to set analysis expression

[LoKi_asterix]

Hi All,
The expression as first expression/Column(1) which counts unique IDs as expected 

Sum(Aggr(If(Count(DISTINCT {$<Year={'$(vMaxYear)'}>} IDs) = 1, 1), IDs))

I have this expression in the next expression tab

IF(COLUMN(1) > 0 AND LEN(TEL) > 0, COUNT(DISTINCT TEL))

I’m looking to optimize this for better performance on the front end by incorporating Set Analysis where possible.

Any suggestions for improvement would be greatly appreciated. Thanks!

[Daniel_Pilla]

It looks like you already have the proper set analysis. Provided that the "IDs" field are unique IDs, the first expression can be replaced with:

Count({$<Year={'$(vMaxYear)'}>} DISTINCT IDs)

or

{$<Year={'$(vMaxYear)'}>} Count(DISTINCT IDs)

For the second, if I'm understanding this properly, if you were to ensure that the empty values of "TEL" are in fact null, you could use

Count({<IDs={"=Count({$<Year={'$(vMaxYear)'}>} DISTINCT IDs)>0"}>} DISTINCT TEL)