filter propagation

Hello @jcamilo1985 ,

I have updated your file, you can get it from this link. Check if the values are correct. Updated information as follows:

1. Update the measurement formula [ sales lastyear] and [ Last monthsales]

ventas año pasado = CALCULATE(ventas[ventas_pbs],SAMEPERIODLASTYEAR('calendario'[keyDate]))​

Ventas ultimo mes = CALCULATE(ventas[ventas_pbs],DATEADD('calendario'[keyDate],-1,MONTH))

2. Create 3 measures and update the measurement formula [goal_sales_regional]

1)Get the sum of commercial pbs2 in table metas_director

00_Meta Comercial Pbs2 = 
var _curdate=MAX('calendario'[keyDate])
return CALCULATE(SUM('metas_director'[Meta Comercial Pbs2]),FILTER('metas_director','metas_director'[fecha]=_curdate))​

Measure = SUMX(VALUES('calendario'[keyDate]),[00_Meta Comercial Pbs2])​

2) Get the sum of commercial pbs2 in table metas_regionals

goal_sales_regional = 
var _curdate=MAX('calendario'[keyDate])
return CALCULATE(SUM(metas_regionales[Meta Comercial Pbs2]), FILTER('metas_regionales','metas_regionales'[fecha]=_curdate))​​

Measure 2 = SUMX(VALUES('calendario'[keyDate]),[goal_sales_regional])

Best regards

Rena