topic Max Value of the Sum of other Column in DAX Commands and Tips

Max Value of the Sum of other Column

Anonymous — Thu, 30 Apr 2020 21:52:28 GMT

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])

Re: Max Value of the Sum of other Column

Greg_Deckler — Thu, 30 Apr 2020 22:21:44 GMT

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])

Re: Max Value of the Sum of other Column

Anonymous — Thu, 30 Apr 2020 23:28:29 GMT

[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