Actual vs. Target: line values fluctuating

[Anonymous]

Hello Power BI enthusiasts, 

Since I'm running ouf ideas, perhaps you may be able to help me. 

I've two following tabbles:  

I'm using the "Line and clustered column chart" to visualize Actual QTY vs Target QTY.  As you may have noticed targets are set for whole year and I think this is causing me a trouble.  

I've created the following meaasure to visualize the Monthly Target QTY:
Monthly target QTY= SUM (Targets[Target QTY]) /12 

I'm using Monthly target QTY as "Line value" which is should be constant number: 
2020:  980/12 =81,6
2021: 761/12 =63,4 

However my line value is fluctuating, while it should be constant. Does anyone has an idea how to fix it? 

pbix. file: http://ge.tt/729TErA3 

[Pragati11]

Hi @Anonymous ,

Can you try modifying your calculation as follows and see if this works:

Monthly target QTY= CALCULATE(SUM (Targets[Target QTY]) / 12, FILTER(ALL(Targets)) )

Thanks,

Pragati

[Anonymous]

Hi @Pragati11 

The following error pops up: 

[Pragati11]

Hi @Anonymous ,

Try removing FILTER expression and try following:

Monthly target QTY= CALCULATE(SUM(Targets[Target QTY]) / 12,  ALL(Targets))

[Anonymous]

Hej @Pragati11 ,

Unfortunately, the line is still fluctuating...

As well as, the monthly target is incorrect..it should be 81,6...

[Pragati11]

Hi @Anonymous ,

On what column are these 2 tables related?

Thanks,

Pragati

[Anonymous]

Hej @Pragati11 , 

I've releated those two columns on "contact"