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 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])
)