Max week set analysis

[klam0001]

Hi,

For my Dashboard KPI, I want to show the data of the current week regardless of any other selections made (this value should never change).

The following expression is what I used:

=Sum({1<_WeekSerial = {$(=max(_WeekSerial))}>} [Count])

I thought the set identifier {1} was used for this exact purpose, however when I select another month it will still take the last week of that month only. I'm guessing this is because of =max().

Is there another way to do it, without adding any variable or changing anything in the script.

Thanks!

[sunny_talwar · Accepted solution]

Try this

=Sum({1<_WeekSerial = {$(=max({1} _WeekSerial))}>} [Count])

[jmmolero]

Hi,

add {1}  to max(..):

Sum({1<_WeekSerial = {$(=max({1}[_WeekSerial]))}>} [Count])