How to show child/parent totals in matrix visualization

[StevenHiatt]

I have a set of sales data by customer. However, some customers have the same parent company. I would like to show in a matrix vizualization the total sales by customer, and include the total sales by parent. Below is what the desired output would look like:

Customer		Parent		Customer Total		Parent Total
Customer1		Parent1		$150		$175
Customer2		Parent1		$25		$175
Customer3		Parent2		$100		$200
Customer4		Parent2		$50		$200
Customer5		Parent2		$50		$200

I've looked at various SUMIF-style solutions but none seem to give me the desired results. Is this possible, and if so what would the DAX be to calculate this?

Much appreciated.

[StevenHiatt]

Thanks so much. Slight change to get the right answer:

calculate([Customer Total], filter( allselected(Table), Table[Parent] = max(Table[Parent])))

but that got me pointed in the right direction.

Just curious what the MAX is doing in the formula? Would MIN or AVG, etc work essentially the same?

[amitchandak · Accepted solution]

@StevenHiatt , based on what I got, a measure for

Parent Total =

calculate([Customer Total], filter( allselected(Table), Table[Customer] = max(Table[Customer])))