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!