Why is KPI not taking selections into consideration?

[jeckstein]

Have a KPI that says

Sum({<Year={2018}>}Sales)

And a filter of Years (2016,2017,2018).

When I select Year 2017. I expect to see a 0 in the KPI but it still shows a number.

Can anyone explain.

[jonathandienst · Accepted solution]

The set expression overrides your user selection. This is the normal/default behaviour. You can override this to create an intersection between the selection and the year in the set expression, like this

     Sum({<Year *= {2018}>}Sales)

[sunny_talwar]

Read more on this topic here:

Implicit Set Operators