Max table value

Question

Hi,&nbsp;I have the following sales visual table where I have calculated the max sales product per employee:&nbsp;EmployeeProductSalesMaxSalesProductMikeA30.83530.835RobertA30.46530.465RobertB14.09230.465MikeA12.78130.835RoseB11.24111.241MikeC7.38230.835RobertD6.97830.465AnthonyA6.7206.720&nbsp;The last column is calculated by the following measure:&nbsp;MaxSalesProduct =MAXX (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CALCULATETABLE (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES ( SalesTable[Product] ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALLSELECTED ( SalesTable[Product] )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SalesTable[Sales]&nbsp;&nbsp;&nbsp; )&nbsp;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?&nbsp;EmployeeProductMaxSalesProductMikeA30.835RobertA30.465RoseB11.241AnthonyA6.720&nbsp;Thanks in advance.

amitchandak · Accepted Answer

Anonymous , check if measure like this can help 
&nbsp;
if(sum(SalesTable[Sales]) = [MaxSalesProduct],[MaxSalesProduct ], blank())
&nbsp;
All other should be grouped/unsummarized&nbsp; columns in visual&nbsp;

Forum Discussion

Max table value

2 Replies

Related content

Max value of a filtered Table

Find MAX Value within a column

Total Min/Max measure where and keep the value static

Max value with a subcategory

Formatting Value of Table

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