User Profile
bassmaninaus_PB
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Dax measure to bring back the max volume date
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!Highlighting the max value in bar chart issue
Hi, I'm trying to highlight the max value in my bar chart, I have it partially working however need help to finalise. As you can see this works with selecting an individual date, however if I select a range of dates or all dates the highlighted bar reverts. One date selected.. Multiple or all dates selected.. The DAX I'm using for the highlight is as follows, any help to get this working, appreciated! Max Interval = VAR MaxInterval = MAXX(ALLSELECTED(Interval),[Avg Calls per Interval]) Return IF( [Avg Calls per Interval] = MaxInterval, 1, 0 )
