How to block filter selection by dimension

[breno_morais]

Hello,

I have this chart and need to show total REFERENCIA witihout the filter change it.

Dimension:

REFERENCIA

Any help?

[neelamsaroha157 · Accepted solution]

use REFERENCIA= in your set analysis expression.

For example if you r expression is sum(Amount) then you can convert it to -

Sum({<REFERENCIA = >}Amount)

[Jesh19]

Put the filters in your set analysis which you doesn't want to have impact on the chart.

Let's say:

If you doesn't want to have an impact when filtering the values on YEAR, Month, Quarter fields. Try it as below:

=Sum({<YEAR=, Month=, Quarter=>}[Total de Ativos])

Else, if you are having too many filters and you want to achieve the same scenario, you can go with Alternate States.