
1. Re: Max per Segment/Superstore
Ben Neville Aug 24, 2018 2:15 PM (in response to Dilyana Suleymanova)Great question, and you're definitely headed in the right direction. You have the right value calculated so far  the max value for each segment each day. The trick is to calculate this as the max for a segment for ALL days. To accomplish this, first find the max for each segment, then compare it to the max value for each segment in each day. If these equal, you've found the right day, and that's where you should draw the dot. If you do the below without everything to the right of the equals sign, you will get the right value, but drawn for every day.
IF SUM({FIXED [Segment] : MAX({ FIXED [Segment], DATETRUNC('day', [Order Date]): SUM([Sales])})})
= SUM([Sales]) THEN SUM([Sales]) END

2. Re: Max per Segment/Superstore
nicolestephanie.osorio Aug 24, 2018 2:23 PM (in response to Dilyana Suleymanova)Exactly what Ben said. You're basically just doing nested LOD calculations.

3. Re: Max per Segment/Superstore
Dilyana Suleymanova Aug 25, 2018 1:43 AM (in response to Ben Neville)thank you so much!