Kpi problem

[sevvalk]

Hello,
When creating calculations with kpi, I automatically set the expression with the filters I selected. There are 2 different kpis, I want one of them to be affected by some filters while not being affected by others. How can I do that?

[Ahidhar · Accepted solution]

Place those filters inside the expression of kpi you don't want to be affected and don't add them in the other kpi

something like this

Sum({<Year={"$(=max(Year)-1)"},Month=,Quarter=>}Billed_Amount) - this one will not get affected

Sum({<Year={"$(=max(Year)-1)"}>}Billed_Amount)