back Has a solution

Total sum of max values?

I'm trying to sum the max values of some items from a table. I have generated an example table for explanation purposes:

City Sales

Buenos Aires 1.000
Buenos Aires 1.000
Mendoza 2.000
Mendoza 500
Córdoba 3.000

How do i grand sum the max values?

Best answer/comment

Sum of Max =
SUMX ( VALUES ( TableName[City] ); CALCULATE ( MAX ( TableName[Sales] ) ) )

Values : To get unique values.

Calculate : Because it will count all 3x Max if you dont use calculate
2019-12-03 11:29:48

Comments

Be polite! In every comment!

Sum of Max = SUMX ( VALUES ( TableName[City] ); CALCULATE ( MAX ( TableName[Sales] ) ) ) Values : To get unique values. Calculate : Because it will count all 3x Max if you dont use calculate
2019-12-03 11:29:48

Comment

You must write a longer mail or/and comment!