Good morning
I have created a measure based on other measures. The measure is calculating the difference between (Actual sales, Opportunties) and planned.
The difference measure is built like this
1. Actual Sales = sum(Actual Sales)
2. Opportunties = Sum(Opportunities)
3. I then created a measure Revenue = Actual Sales + Opportunties.
4 Then I calculated the difference. Diff = Planned Sales - Revenue
5. I want to create a Stacked Bar chart with all measures above so the difference amount is shown, so I created a new measure. All = Revenue + Diff and this doesn't work as expected. It show the full amount of the plan instead of the difference to plan
Does anyone know how i can achieve my goal?
Thank you
When I put the Diff measure in a Matrix it works as expected
