Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Max table value

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , check if measure like this can help

     

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

     

    All other should be grouped/unsummarized  columns in visual 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It works! Many thanks amitchandak.

 

Regards