Forum Discussion
Divide chart values to total
Greetings everyone, I got stuck in a problem with probably a simple solution. I have a chart of products with actual selling(grey bars) and goal on selling(green bars). I need to divide t...
If ActualSelling is your measure,
TotalSelling = CALCULATE( [ActualSelling], ALL(Table[Product]) )
You can create another measure TotalGoalSelling by the same way
Then you can create the final measure as = DIVIDE(ActualSelling,TotalSelling)
This is the right idea but I need to find a formula to split the total on products, like create a second measure from the one that was generated by the chart that looks exactly like the chart and after that divide them.
Basically the picture that I posted was generated, I need to find out a formula that does the same thing but I am the one writing it, not generating from drag and drop.
If you use the final measures as sugested and drag this measure in your bar chart with product on X Axis, it would works fine