Replace Value for a group with Total

[TravisGlanzer]

I have a DAX that sums Product from a detailed table.  I would like to take the measure a step farther and enter the sum of the products for a particular group when the Division is S.  For example, for Division S in Group X, the answer should be 10 + 12+15=37.  The Division S for Group Y should be 43.  I do not care about totals as those are removed from my presentation.

Division	Group	Product
N	X	10
W	X	12
S	X
E	X	15
N	Y	12
W	Y	13
S	Y
E	Y	18

[wdx223_Daniel · Accepted solution]

measure=if(selectedvalue(table[division])="S",calcluate(sum(table[product]),all(table[divsion])),sum(table[product]))