Show value associated with a calculation in another column

Question

Hi All,&nbsp;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. &nbsp;Largest Instructing Client Share Result = MAXX(KEEPFILTERS(VALUES('ForecaseAndActual'[Instructing Client])),CALCULATE(SUM('ForecaseAndActual'[Order Amount (excl. VAT)]),USERELATIONSHIP('Date'[Date],ForecaseAndActual[Order Received])))&nbsp;I want to show the associated Instructing Client that the resulting value is displaying.&nbsp;Data is formatted as follows:&nbsp;Instructing ClientOrder ReceivedOrder Amount (excl. VAT)A05/03/2019&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9,500.52B20/03/2019&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 119,380.00C19/03/2019&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9,556.00D06/03/2019&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 91,860.00D06/03/2019&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52,310.00E11/03/2019&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,500.00&nbsp;Any help would be appreciated. Many thanks.

greg_deckler · Accepted Answer

Perhaps something along the lines of:
&nbsp;
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])

Forum Discussion

Show value associated with a calculation in another column

1 Reply

Related content

Associate Identity to fabric Item

Calculate new column based on another column's text

Associated identities for items (Preview)

MoM calculation

calculated column using another table scan

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