Max from the Grid values

Hi sabeensp

Try this for your measure in the Card visual:

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

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.