Forum Discussion

MiguelSaldana77's avatar
MiguelSaldana77
Resolver I
6 years ago

Filter Exclude Period

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?

 

Need Help

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    6 years ago

    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