Filter Exclude Period

[MiguelSaldana77]

Hi Everyone, I have a Problem with a Calculate Measure.  This is the formula that I have:

TEST = if(HASONEVALUE('Indicadores Bancos'[IdConcepto_Flujo])
, IF(VALUES('Indicadores Bancos'[IdConcepto_Flujo])=196,
CALCULATE( Sum('Indicadores Bancos'[Total Bancos Miles Columna]),FILTER(ALL('Indicadores Bancos'),'Indicadores Bancos'[IdConcepto_Flujo] In {560,190,195}),ALLSELECTED('Cat Tiempo'))
, Sum('Indicadores Bancos'[Total Bancos Miles Columna])))

The Problem is when I show the indicator on a table that have Months on Columns, The Calculation just accumulates all on January

What Do I miss?

 

[v-piga-msft]

Hi @MiguelSaldana77 ,

Based on your formula, I cannot find any problem.

If it is convenient, could you share the data sample as table format and your desired output so that I could have a test on it?

Best  Regards,

Cherry