Max of amount on a specific column

[Deepikasubu]

Hi,
Below is the data i have:
Table 1:

Code	RV
2017-00145	40.3
2017-11401	30.85
2017-00142	22.3
2017-11101	2.75
2017-1036F	2.74
2017-17000	2.5
2017-12031	2.45
2017-11100	1.27
2017-00140	1.25
2017-11402	1.22
2017-17003	1.22
2017-11042	0.6

Table 2:

LOB	Name	Code
MED	MAC	2017-00140
MED	MAC	2017-00142
MED	MAC	2017-00145
MED	SWD	2017-1036F
Not Specified	SWD	2017-1036F
COM	MRJ	2017-11042
COM	RTD	2017-11100
COM	RTD	2017-11101
MED	RTD	2017-11101
COM	RTD	2017-11401
MED	RTD	2017-11401
COM	RTD	2017-11402
MED	RTD	2017-11402
COM	RTD	2017-12031
MED	RTD	2017-12031
COM	RTD	2017-17000
MED	RTD	2017-17000
MED	RTD	2017-17003

Table 1 and Table 2 is joined by code with  1 to M relationship having cross filter direction enabled (BOTH).

Expected Result:

Name	RV	Measure
MRJ	0.6
MAC	63.85
RTD	42.26	63.85
SWD	2.74

In the "Measure" above i need max of the "RV" displayed only for Name="RTD".
can anyone help? i tried so many ways, but ended up with 42.26 itself...

[Greg_Deckler · Accepted solution]

Measure = 
VAR myTable = SUMMARIZE(ALL(Table2),Table2[Name],"RV",CALCULATE(SUM(Table1[RV])))
VAR theMax = MAXX(myTable,[RV])
RETURN IF(MAX([Name])="RTD",theMax,BLANK())

[Deepikasubu]

Thanks it was really helpful