I need this result

[Aniket_Bhande]

customer    product    quntity

c1                P1                20 

c1                P2                  30

c2                P3                 290

c2                 P4             110 

c2                P5                  60

RESULT I WANT

customer   product    quntity

c1             p2             30  

c2             p3            290

[v-yangliu-msft · Accepted solution]

Hi  @Aniket_Bhande ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _max=
MAXX(FILTER(ALL('Table'),[customer]=MAX('Table'[customer])),[quntity])
return
IF(
    MAX('Table'[quntity]) =_max,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[AilleryO]

Hi,

This should do the trick :

SUMMARIZECOLUMNS( Data[Customer] , "Max Qty" , MAX( Data[Qty] ), "Prod" , MAX( Data[Product] ) )

Use it in a function, or as a new table.

Let us know if it works 

[Aniket_Bhande]

its not work

[AilleryO]

Hi,

It does work if you use it as a new table, not as a new measure or column.

Otherwise you can try the solution of @v-yangliu-msft .

Let us know what is best solution for you

[Aniket_Bhande]

SEE This

[AilleryO]

Hi,

Not 100% sure about your need, but replace MAX by MIN and you should have expected result :

SUMMARIZECOLUMNS( Data[Customer] , "Max Qty" , MAX( Data[Qty] ), "Prod" , MIN( Data[Product] ) )

Let us know