Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 ...
  • wardy912's avatar
    1 year ago

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