Total sum of max date values

[MontyZero]

Hi

I am trying to get the maximum value for each company in a filtered table. This is the dax I have been using 

Most Recent Total Value:=
VAR maxdatekey=
MAXX(FILTER('Reporting Table',
'Reporting Table'[ReportingDateKey] <= [ReportingDateParamEnd]
&& 'Reporting Table'[ReportingDateKey] >= [ReportingDateParamStart]
&& 'Reporting Table'[Scenario] = "Total Value"
),
'Reporting Table'[ReportingDateKey])
RETURN
(
CALCULATE([NumericValue], 
FILTER('Reporting Table',
'Reporting Table'[Scenario] = "Total Value"
&& 'Reporting Table'[ReportingDateKey] = maxdatekey
)
)
)

I filter the table based on dates selected, and a scenario to generate the maximum date value. I then use the same filters plus the max date to return the amount required.

At a granular level the measure works correctly with the following output

CompanyID	ReportingDateKey	Most Recent Total Value
1	20180101	100
2	20180101	100
3	20180101	200
4	20140101	300
5	20180101	100
		800

The issue arises when I remove the granular slicers. The max date is calculated to be 20180101 and the filter causes CompanyID 4 to be excluded. The total returns as 500 rather than 800.

Most Recent Total Value

500

Is there a way to force the calculation to calculate the total correctly?

Thanks in advance

Michael

[Greg_Deckler · Accepted solution]

See if this Quick Measure, Measure Totals, The Final Word gets you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[MontyZero]

Great! Thanks Greg.