Total value variation column chart

[Anonymous]

Hello all ,

i have sample data like below  want to show total value column in graph 

measure : 

variation = sum('Master Data Base'[Value])

Master data base :

Reduction Buckets                               Value

1.overstock consumption                       4.7

2.scrap                                                    -0.6

3.supply improvements                         1.6

4.sell back oms                                       0.4

5.New materials                                     -4.6

Now  graph looks like 

How to get total  Values   graph like below 

thanks in advance. any option to do that ?  there is no option for data lable for total . 

[Anonymous]

@VahidDM  both values  come from single table  Master data base only .  Reduction Buckets ,values its two column .  

[Anonymous]

i  have  Reduction Buckets    totaly 10 list but i am selecting only 5 values 

[VahidDM]

The number of items won't make any issue with that code.

Appreciate your Kudos!!

[Anonymous]

@VahidDM  Each table argument of 'UNION' must have the same number of columns i am getting this warning 

[VahidDM]

Yes, The two tables must have the same number of columns.

https://docs.microsoft.com/en-us/dax/union-function-dax

If you have a table with many columns, summarize that.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[Anonymous]

@VahidDM  thank you so much 

[VahidDM]

No Worries

🙏

[VahidDM · Accepted solution]

Hi @Anonymous 

Download this file:

https://gofile.io/d/NrNWmb

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!