ignore filter in KPI

[georgianamha]

Hello,

I have made the KPI for YTD using this calculation:

sum({<YEAR={"$(=max(YEAR))"},MINTHNUM= {"<=$(=max(MONTHNUM))"} > }line_amount)

Obviously if i put any filter (year or month or product or manufacturer etc) the value is changing

i read that if i add {1} the KPI will ignore all filters, but in my case is not working.

If i make it like this sum( {1} {<YEAR={"$(=max(YEAR))"},MINTHNUM= {"<=$(=max(MONTHNUM))"} > }line_amount) is not change

and if i add it at the end, like this sum({<YEAR={"$(=max(YEAR))"},MINTHNUM= {"<=$(=max(MONTHNUM))"} > }{1} line_amount)

all filters are ignored but the value is changed from 3.7 M to 24.7 M and i noticed that this value is the total for all years

Do you have any advice? 🙂

Thank you for support!

[Or]

Your inner max() functions in the set analysis are also looking at selections, so you'll need to tell those to ignore selections as well, i.e. max({1}Year) or max(all Year)

[sidhiq91]

Try adding 1 without the {}. Just before set modifier. See if that helps

[georgianamha]

Thank you! Worked 🙂