Aggregate sales for parent company

[idrabble]

Hello All,

I am currently trying to produce a dashboard that will work for each of our customers to show their sales performance this fiscal year compared to the last.

I have had no issues with all the work I have carried out so far however I have stumbled on the last issue.

Some of our customers sit within a parent company and I would also like to demonstrate the parent performance.

However I am unable to create a matrix/table that shows the total sales volumes for the group. My issue is that some customers sit with different sales team members and I am placing a filter on the report to only show the customers with the selected team member and this then excludes any customers from within the group being summed in the matrix/table.

Is there a measure or visual that I can use to show the total group sales independent of the selected sales team member and selected customer?

Below is an image of the data table rpoduced by my SQL query:

I would like to visualise the total quantity by Salon_Group when I select each customer in the dashboard below:

Many thanks in advance, Ian

[v-chuncz-msft · Accepted solution]

@idrabble,

You may add a measure below.

Measure =
CALCULATE ( SUM ( Table1[Quantity] ), ALL ( Table1[CustomerName] ) )