Trying to sum one value per unique column value

[Anonymous]

I have a row that has the totals per Category in row 2. What I'd like is to not sum the total of row 2 because that would be way too much, but only sum one value in row 2 per Category. The granularity also needs to be kept. I pretty much need a DAX calc that will make the sum of column 2 be equal to the sum of column three by only summing one value from column 2 per Category so both grand totals for column 2 and 3 are 2500. Right now, column two will be 7500, which is over-summing.

Category	Total	Commission
A	1000	$                                   400.00
A	1000	$                                   200.00
A	1000	$                                   400.00
B	1500	$                                   500.00
B	1500	$                                   500.00
B	1500	$                                   500.00

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

Sum Total measure: = 
SUMX ( SUMMARIZE ( 'Data', 'Data'[Category], 'Data'[Total] ), 'Data'[Total] )

[vapid128]

calculate(sum([commission]),allexpet(table, table[Category]))