Dax measure to bring back the max volume date

[bassmaninaus_PB]

Hi,

I have a card displaying the maximum daily volume over a 12 month period.

Measure is this: Max Daily Volume = MAXX( VALUES(Dates[Date]), [Total Forecast Volume])

I'm trying to create a tooltip so when hovering over that card, a table displays with all the records of just that day that has the maximum volume.

The Card is correct with 13K on the maximum day and that lines up with the total of the tooltip, with 12,979 as the total. However it is showing all dates, I just want that maximum day to show. i.e the actual day with the maximum daily volume of 12,979 is 16th April 2024.

Any ideas greatly appreciated.

My thoughts are to create a measure that calculates that max volume day, returning 1 or 0 then using in the card filter, however need help!

[amitchandak · Accepted solution]

@bassmaninaus_PB , Try like

calculate( MAXX( VALUES(Dates[Date]), [Total Forecast Volume]) , allselected())

or add 12 month filter

12 Month Avg = CALCULATE(MAXX( VALUES(Dates[Date]), [Total Forecast Volume])
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))