CALCULATE a SUM with FILTER

[Anonymous]

Hi everyone,

I have been trying the whole day to sum a column applying some filter on it. I got the first formula that I'm using the value of a slicer in a condition with a lookup to get the correct date format, and then another simple condition.

CALCULATE( 

SUM( GRC_F_KPI[KPI_VALUE] );
FILTER( GRC_F_KPI; GRC_F_KPI[DATE] = LOOKUPVALUE(GRC_F_KPI[DATE]; Test_Period[MONTHOFYEAR]; ALLSELECTED(Test_Period[MONTHOFYEAR])) && GRC_F_KPI[COD_KPI] = "CB-11")
)

To this value I would like to deduct the month before value. In order to get that I'm using this formula but it does't work.

CALCULATE( 

SUM( GRC_F_KPI[KPI_VALUE] );
FILTER( GRC_F_KPI; GRC_F_KPI[DATE] = EDATE ( LOOKUPVALUE( GRC_F_KPI[DATE]; Test_Period[MONTHOFYEAR]; ALLSELECTED(Test_Period[MONTHOFYEAR] ) ); -1) && GRC_F_KPI[COD_KPI] = "CB-11")
)

Thanks for your help.

[v-frfei-msft]

Hi @Anonymous,

Kindly share your sample data and excepted result to me.

Regards,

Frank

[Anonymous]

Eventually, it was a filter problem. Thanks anyway.

[v-frfei-msft]

Hi @Anonymous,

Kindly mark your answer as solution to close the case please. thanks in advance.

Regards.

Frank