cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

filter propagation

Good Morning
I think I have done something wrong in my data model, model OneDrive, and I do not know how to solve it, for this reason I go back to you that you can always guide me in the best way.

 

the situation is that, on the one hand, the time measurements are not working as expected, for example with the previousyear or previousmonth functions the calculation is not performed and the truth is I do not know why this happens.

jcamilo1985_0-1600706840933.png    

jcamilo1985_1-1600706864763.png

Another aspect is that I need a table that shows the fulfillment of the goal that is in the table "regional goals" discriminated by date, but it is not filtered in the correct way despite the fact that they are with both a filter type between regions and goals.

Can someone please tell me why this behavior is occurring

jcamilo1985_3-1600706966080.png

jcamilo1985_4-1600707128431.png

jcamilo1985_5-1600707192811.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: 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])

filter propagation.JPG

Best regards

Rena

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: 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])

filter propagation.JPG

Best regards

Rena

View solution in original post

Highlighted
Helper I
Helper I

Re: filter propagation

@yingyinr simply brilliant, thank you very much for your help, congratulations

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (769)