Max table value

[jjimnz20]

Hi,

I have the following sales visual table where I have calculated the max sales product per employee:

Employee	Product	Sales	MaxSalesProduct
Mike	A	30.835	30.835
Robert	A	30.465	30.465
Robert	B	14.092	30.465
Mike	A	12.781	30.835
Rose	B	11.241	11.241
Mike	C	7.382	30.835
Robert	D	6.978	30.465
Anthony	A	6.720	6.720

The last column is calculated by the following measure:

MaxSalesProduct =

MAXX (

        CALCULATETABLE (

            VALUES ( SalesTable[Product] ),

            ALLSELECTED ( SalesTable[Product] )

        ),

        SalesTable[Sales]

    )

I also need to know what product corresponds to the most sold product by employee. How can I get something similar to the following visual table without repeated values?

Employee	Product	MaxSalesProduct
Mike	A	30.835
Robert	A	30.465
Rose	B	11.241
Anthony	A	6.720

Thanks in advance.

[jjimnz20]

It works! Many thanks @amitchandak.

Regards

[amitchandak · Accepted solution]

@jjimnz20 , check if measure like this can help

if(sum(SalesTable[Sales]) = [MaxSalesProduct],[MaxSalesProduct ], blank())

All other should be grouped/unsummarized  columns in visual