DAX to show Total value by Month highlighting High and Low or Max and Min data points.

[Anonymous]

Hello Community Members

I'm struggling with this DAX, objective is to create a measure to show High and Low data points for total utility consumption per month. The date is coming from the date table which got Date, Year, Month of Year, Quarter of Year, Day of Month as field list.
[Total Utility] is DAX measure.

With this DAX, I'm aiming to achieve 1 against High and Low value by month and then with the help of conditional formatting, I highlight '1' in my Line chart or Clustered Column. But somehow my DAX is not working, Ideally i like to see 1 against the blue circled value., instead I'm only getting 1 for the highest value for the whole selected range for the year.

Tried using MINX / MAXX with ALLSELECTED or SUMMARIZE and ADDCOLUMNS nothing working. My current DAX which is not giving the desired output is below mentioned. Please suggest any tweaks or new DAX.

OVERALLMAXMIN =

VAR ELECTRIC = [Total Electric]

VAR MAXELECTRIC =

MAXX(ALLSELECTED('Date'[Year],'Date'[Month]),[Total Electric])

VAR MINELECTRIC =

MINX(ALLSELECTED('Date'[Year],'Date'[Month]),[Total Electric])

VAR RESULTS =

IF(ELECTRIC=MAXELECTRIC || ELECTRIC=MINELECTRIC,

1,

0

)

RETURN

RESULTS

[lbendlin]

IF(ELECTRIC=MAXELECTRIC || MAXELECTRIC=MINELECTRIC

Did you want to write

IF(ELECTRIC=MAXELECTRIC || ELECTRIC=MINELECTRIC

?  You  can also use the IN {} construct if you want.

[Anonymous]

Thanks @ibendlin