Max Value of the Sum of other Column

[Anonymous]

Hello My Friends,

How Are you?

I really need some help

I have some Data like:

Name	Date	Class	Value
A	01/10/2015	One	100
B	01/10/2015	Two	100
C	03/10/2015	One	205
D	12/31/2015	One	320
E	08/10/2016	Two	130
F	09/11/2016	Three	30
G	09/12/2016	Three	60
H	10/20/2016	Three	90

And this Table Goes on with a lot of others rows.

I wanna Show inside a Card the "Class" wich presents the higher SUM of its VALUE's  on a Card.

At the exemple above i would put a Card in my Dashboard and it would be written: "One" , Because "One" VALUE's Sum  is Higher than "Two" VALUE's Sum or Three VALUE's Sums.

Does anyone knows how to Create a Measure to do this?

I Tried something like:

=MAXX( TOPN ( 1 ; DataSource ; DataSource[Value] ; Desc) ; DataSource[Class])

[Anonymous]

[Best Class] =
var __bestClasses =
	topn(1,
		VALUES( T[Class] ),
		CALCULATE( SUM( T[Value] ) ),
		DESC
	)
// You have to do this in case
// you have ties.
var __toString =
	CONCATENATEX(
		__bestClasses,
		T[Class],
		", ",
		T[Class],
		ASC
	)
return
	__toString
	
// If you don't want ties, then
// you can return the first or last
// class (alphabetically). Here's
// the version:
[Best Class] =
	// Remove the one you don't want
	MINX( // for the first class
	MAXX( // for the last class
		topn(1,
			VALUES( T[Class] ),
			CALCULATE( SUM( T[Value] ) ),
			DESC
		),
		T[Class]
	)

Best

D

[Greg_Deckler · Accepted solution]

I would do something like this:

Measure =
  VAR __Table = 
    SUMMARIZE(
      'Table',
      [Class],
      "__Sum",SUM('Table'[Value])
    )
  VAR __Max = MAXX(__Table,[__Sum])
RETURN
  MAXX(FILTER(__Table,[__Sum] = __Max),[Class])