Sum the Value By Day and Return The Max Number Over DataSet

[zl34567]

Hi All,

Im trying to sum the No. of Staff of a Date on a specific Date and then secondly trying to get it to return the Max Number. 
I have a DateTable to combine two data sets one for Availablity and the other for forecast.

Im trying to get it to return the MAX number on either the required number or the Ave per Week so that the scaling will match. Currently as it is it is causing confusion.

Thanks in Advance

[tamerj1 · Accepted solution]

Hi @zl34567 
The Max/Min value of the chart Y axis / secondary axis is evaluated outside the filter context of the visual itself. Hence, it needs to be created inside the measure. Plerase try:

MaxMeasure =
MAXX ( VALUES ( 'Table'[Date] ), MAX ( [Required Staff No.], [Ave Per Week] ) )