Is there a way to stop a chart from automatically updating when clicking a filter?

[Shu]

I have a KPI, filters, and 2 other charts. Is there a way to keep the KPI from automatically updating when I click on the filters but allow the other 2 charts to continue updating based on the filters? For example, let's say the KPI has a value of 87%. Regardless of the filter I click on, I would like to keep the KPI at 87% while the other 2 charts change as needed depending on the filters. 

Any help on this issue is greatly appreciated. 

Thanks,

Shu

[Øystein_Kolsrud]

I guess it depends on the expression you are showing in the KPI, but you should be able to use set analysis for it I guess. If your expression is "Sum(Sales)", then you could replace it by "Sum({1} Sales)" which will ignore your selections.

[Shu]

Thank you for the quick reply. Below is my expression for the KPI:

Count(if([value1], [value2]))
/
Count([value2])

Do you know how I would apply the {1} to the above expression?

[Øystein_Kolsrud · Accepted solution]

Yes, I think you should be able to write like this:

Count({1} if([value1], [value2])) / Count({1}[value2])

[Shu]

That worked! Thank you so much for your help!