Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @krista_003 ,
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
Hi @krista_003 ,
Try removing FILTER expression and try following:
Monthly target QTY= CALCULATE(SUM(Targets[Target QTY]) / 12, ALL(Targets))
Hej @Pragati11 ,
Unfortunately, the line is still fluctuating...
As well as, the monthly target is incorrect..it should be 81,6...
User | Count |
---|---|
51 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |