Getting the maximum date of the current selection

[manu1512]

i  am using following KPI in line chart

=Sum({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'N'},Flag ={1},Mod_EquipmentStartDate={"<=$(=(Max(DateID)))"},Valid_From_Date={"<=$(=(Max(DateID)))"}>}   EquipmentCount) +

sum({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'Y'}

,Flag ={1},Mod_EquipmentStartDate={"<=$(=(Max(DateID)))"},Valid_From_Date={">$(=(Max(DateID)))"}>}   EquipmentCount)

Whenever i am putting following KPI in line chart ,

I am getting a different value for particular year if i made of  selection of  that year ,but without selection we are getting different value.

This is because when i am not selecting any year it is giving me overall maximum date of DateID ,But when i am selecting particulat year it is giving maximum date id of that year.

Can any one tell me how to  modify this logic so that it compares only the particulat year maximum date id only when i am not making selection ?

[swuehl]

The dollar sign expansion as well as set analysis is evaluated in global context, not per your chart dimensional values.

Is Year a dimension in your chart?

Then the current expression will not 'look' at the current dimensional Year value and use this to determine the max DateID, just as you've noted.

It's hard to give you a more precise help without knowing anything about your context, model and data.