Measure that calculates the maximum hourly sum for each day

[bevicor]

I have a Power BI report with an area chart that compares hourly forecast data vs actual data. This data is the summation of multiple categories that can be filtered by a slicer. I have been asked to set a flag on the maximum hourly forecast value for each day in the chart, but the hour changes depending on which subset of categories have been selected. I think I need a measure that returns the same maximum hourly value for each hour in the day, but I can't figure it out. I tried 

MaxDailyForecastMeasure = 
         MAXX(SUMMARIZE(dr_load_history_postfactor,dr_load_history_postfactor[Timestamp],"MaxDay",SUM(dr_load_history_postfactor[FcstLoad])),[MaxDay])

But that just returned the hourly sum on the chart. See the pic below - the yellow just follows the blue, but I want it to pick the peak blue value each day. Any thoughts would be greatly appreciated.

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file.  Show the expected result in a simple Table format.

[bevicor]

Thanks for the reply Ashish. I'm new to this community, how do I add an Excel file here? I'll include sample data once I figure that out, but I can't provide the desired output, because it's variable. I want the max daily amount for any subset of my "Rate" categories based on whichever rate(s) the user picks to see in a chart on the report. But the chart is hourly, so every measure I've tried just returns the hourly value instead of the max daily value for every hour of that day.

[Ashish_Mathur]

If ou cannot share the sample result in a table, then i will not be able to help you.  Someone who understands your question will surely help you.