Set Analysis

[elenarelinque]

Hi!

I have this expression and I'm trying to avoid any filter:

sum({1<Month_PNC={"$(=Date(Max(Month),'MMM-YY'))"},[FASE]={'422','430','440','442'},[Tipo parada]=,DESC_MAQUINA=,[Elemento asociado]=,[TURNO]=,[Motivo]=,[Mes]=,[Fecha_Comun]=,[Semana]=,[Dia]=>}aggr(sum({1<Month_PNC={"$(=Date(Max(Month),'MMM-YY'))"},[FASE]={'422','430','440','442'},[Tipo parada]=,DESC_MAQUINA=,[Elemento asociado]=,[TURNO]=,[Motivo],[Mes]=,[Fecha_Comun]=,[Semana]=,[Dia]=>}DISTINCT [CANTIDAD_RECHAZADA]), [ID_RECHAZO]))

But when I select a month it afects my KPI:

Thank you in advance!

[Mark_Little]

Hi,

I believe your issue is related to the 1 at the start and then the use of[Mes]=,.

The 1 means use the whole data set and ignore selection. Adding [Mes]=, says in this case ignore my exclusion of this field.

So either remove all the [Field Names]= from the set analysis or the 1. 

[elenarelinque]

Thank you by none of the options are working.