Calculation Performance

[#1]

May be an interesting debate, I have just took over a QV dashboard and from looking at the calcs it has raised this question in my head.

One of the calcs,

sum(if([Year]='2016'and [Week]='1',[Age]))

I would have written as

Sum({$<Year={$(=2016)},Week={$(=1)}>}Age)

Which version of the calc would you say is the best for the overall performance of the dashboard? and to expand my knowledge why?

[sunny_talwar]

I would use set analysis, but with slight changes

Sum({<Year = {2016}, Week = {1}>} Age)

This because set analysis is evaluated once per chart and should lead to some better performance