Variance bar chart

[Chxlsea_]

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 the only reason the left table shows the correct figures for standard cost is because of the serial number. Following the left table standard cost for this air inlet casing show be £8,043 in total. Instead the bar chart shows £5k. This is because the Standard cost sheet has various different engine types and all it is doing is summing those. For instance there may be 3 different air inlet casings because engine 1 has one at a standard cost of £2.5k, engine 2 has one at £1 and engine 3 has one at £1.5k. I need the right table to recognise the different engine types shown in the left table and sum that instead. There is currently a relationship set up in another sheet which links the engine type to the serial number, hence why the left table works. 

[v-hjannapu]

Hi @Chxlsea_,
Thank you  for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank @wardy912 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Harshitha.

[v-hjannapu]

Hi @Chxlsea_,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Harshitha.

[v-hjannapu]

Hi @Chxlsea_ ,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.

Regards,
Harshitha

[wardy912 · Accepted solution]

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

[wardy912]

You don't appear to have pressed the 'expand all' button on the bar chart visual

[Chxlsea_]

Thank you this has worked however what i was looking for was a total. in this case it would be £8,043. 

[wardy912]

Hi @Chxlsea_ 

You'll need to write a DAX measure that uses the correct relationship to get the right visual working.
Please provide sample data so that I can replicate the issue to provide a detailed fix.

[Chxlsea_]

This is the standard sheet 

This is the sheet containing the serial number and engine type 

[wardy912]

Thanks, no measure needed actually.

I used dummy data as images aren't usable here.

Add the serial number to the y-axis on the bar chart visual

Click the expand hierarchy button on the visual

It will display sub assembly and serial number concatenated.

I hope this helps, please give a thumbs up and mark as solved if it does, thanks!

[Chxlsea_]

Hi, thank you but mine doesn't seem to do this