MAX of sum per service

[Jay20024]

Hi Folks,

Had a horizontal bar chart showing the SUM of transaction cost for each service.

I'd like to calculate the amount of the most expensive service (here it's "compute") in dax.

As MAX only refers to a column, 

How can I do that ? I thank you in advance folks !

[techies]

Hi @Jay20024 please check this

MaxServiceCost =

MAXX (

    SUMMARIZE ( 'Table', 'Table'[Service], "TotalCost", SUM('Table'[Transaction Cost]) ),

    [TotalCost]

)

[Jay20024]

Let me precise how my dataset works. Hope it will be clearer. I'd like to find 200 through a dax measure.

[Jay20024 · Accepted solution]

ok I found it  : with top N function :

= SUMX( TOPN( 1, SUMMARIZE( InternetSales, InternetSales[ProductKey], "TotalSales", SUM(InternetSales[SalesAmount]) ), [TotalSales], DESC ), [TotalSales] )

[mdaatifraza5556]

Hi @Jay20024 

Is this the result you want?

If this answers your questions, kindly accept it as a solution.
If this is helpful, then please give kudos.

[Jay20024]

You gave a good clue  !

= SUMX( TOPN( 1, SUMMARIZE( InternetSales, InternetSales[ProductKey], "TotalSales", SUM(InternetSales[SalesAmount]) ), [TotalSales], DESC ), [TotalSales] )