Show value associated with a calculation in another column

[KrisT]

Hi All,

I'm having trouble with displaying a value associated with a calculation in another column. The formula below shows the maximum Instructing Client share (based on the Order Value (excl. VAT)) for a particular Year/Quarter/Month determined by a Date slicer.

Largest Instructing Client Share Result =

MAXX(

KEEPFILTERS(

VALUES('ForecaseAndActual'[Instructing Client])),CALCULATE(

SUM('ForecaseAndActual'[Order Amount (excl. VAT)]),USERELATIONSHIP('Date'[Date],ForecaseAndActual[Order Received]

)))

I want to show the associated Instructing Client that the resulting value is displaying.

Data is formatted as follows:

Instructing Client	Order Received	Order Amount (excl. VAT)
A	05/03/2019	£                   9,500.52
B	20/03/2019	£               119,380.00
C	19/03/2019	£                   9,556.00
D	06/03/2019	£                 91,860.00
D	06/03/2019	£                 52,310.00
E	11/03/2019	£                   6,500.00

Any help would be appreciated. Many thanks.

[Greg_Deckler · Accepted solution]

Perhaps something along the lines of:

VAR __max = 

MAXX(
KEEPFILTERS(
VALUES('ForecaseAndActual'[Instructing Client])),CALCULATE(
SUM('ForecaseAndActual'[Order Amount (excl. VAT)]),USERELATIONSHIP('Date'[Date],ForecaseAndActual[Order Received]
)))

VAR __table = SUMMARIZE('ForecaseAndActual',[Instructing Client],"__orderAmount",CALCULATE(
SUM('ForecaseAndActual'[Order Amount (excl. VAT)]),USERELATIONSHIP('Date'[Date],ForecaseAndActual[Order Received]
)))

RETURN

MAXX(FILTER(__table,[__orderAmount]=__max),[Instructing Client])