Forum Discussion
Variance bar chart
I currently have two visuals as shown below. What I would like is for the right visuals figures to match the lefts but as a summary. there is a lot going on in the background data wise but currently ...
You could create a measure and add it as a tooltip
Total Actual Cost per Sub Assembly = CALCULATE( SUM(SubAssemblies[Actual Cost (£)]), ALLEXCEPT(SubAssemblies, SubAssemblies[Sub Assembly]) )
You don't appear to have pressed the 'expand all' button on the bar chart visual
Thank you this has worked however what i was looking for was a total. in this case it would be £8,043.