Display sliced totals + grand Total on the same chart

[KellyDittmar]

I have a few line & bar charts similiar to the attached with show information based on departments. I have a request that in the tooltip I show not only the value per department - but also the total sum of all departments (in this case 4,732,413). The data source is a tabular cube and the value is a measure within the cube.

I searched thru the options for the charts and seeing nothing there I believe I need some DAX to accomplish this? So far, I am unsuccessful at writing any DAX that when combined into this chart avoids being filtered by department... Is there anyone who can give me a hint to get me started on the right path? 

The line chart and the bar chart are two different areas of my same tabular cube - and both have the same request to have the grand total as well as the sliced values... (edited to add that second photo)

  

[Anonymous]

Divide([value], calculate ([value], all(table[department])))

A modification of that should be close to what you are looking for. Check out the documentation for the ALL Dax function.

[KellyDittmar]

I'm a little confused - I already have the divided value - I need the summed value... 

Both Calculate & All display the sliced value when added as a measure to the tooltip. 

[Anonymous · Accepted solution]

Sorry, I misread your question. You only need the second half of that divide function I gave. Hence
Calculate ([value]), ALL(table[department]))
This should provide you a value of the sum without the department's filtering the value.

[Anonymous]

https://msdn.microsoft.com/en-us/library/ee634802.aspx
This is how the all function works.

Hopefully I haven't misunderstood you this time.