Max from the Grid values

[sabeensp]

Hello,

 I have  a Grid

Colum 1   -------- Sum of Sales Amount (its a SUM measure)
Product A -------- $100

Product B -------- $300

Product C -------- $50

Product D -------- $450

Product E -------- $100

I need to show in a Card as a seprate visual

$450

Which is the max of all product sales

Thanks

[v-danhe-msft · Accepted solution]

Hi @sabeensp,

Based on my test, you could refer to below formula:

Measure = MAXX('Table1','Table1'[Sum Measure])

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @sabeensp,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @sabeensp,

Based on my test, you could refer to below formula:

Measure = MAXX('Table1','Table1'[Sum Measure])

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[ssugar]

Assuming you have a fact table that has products and prices like this:

Product    Price

A               200

A               200

A               50

B               100

B               100

C                70

C                80

you could try something like this:

Max Product Price = 
    var __table = SUMMARIZE(Table1, Table1[Product], "Price", SUM(Table1[Price]))
    return MAXX(__table, [Price])

Essentially, I'm just summarizing the fact table to group up the product column, and aggregate (sum) the price column, and then returning the max of that price column.

Hopefully this helps.

[AlB]

Hi @sabeensp

Try this for your measure in the Card visual:

CardMeasure =
MAXX (
    SUMMARIZECOLUMNS ( Table1[Column] );
    CALCULATE ( SUM ( Table1[Sales Amount] ) )
)