Highest value in a day

Hi,

One of ways is to utilize visual calculation.
Please check the below picture and the attached pbix file.

Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn

Hi jobf ,

 One thing you could try is to create a measure that sums the value, then add that measure to the visual instead of the value itself. In that situation, there would be a single value per day which would make it very easy to see the highest value or day with highest value.

That would be 

MaxDaily =
MAXX (
VALUES ( 'Table'[Date] ),
CALCULATE ( SUM ( 'Table'[Value] ) )
)

Use MAXX(VALUES(Date)) to iterate once per distinct date in the current context, and put this measure in a card visual.

Hi,

Write these measures

V = SUM(Data[Value])

Measure = MAXX(VALUES('Calendar'[Date]),[V])

Hope this helps

Hi jobf 

Try the following measures:

Max value in a single day = 
MAXX ( ALLSELECTED ( 'Table'[Date] ), CALCULATE ( SUM ( 'Table'[Value] ) ) )

Day with the max value = 
MAXX (
    TOPN (
        1,
        ADDCOLUMNS (
            SUMMARIZE ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] ),
            "@value", CALCULATE ( SUM ( 'Table'[Value] ) )
        ),
        [@value], DESC
    ),
    [Date]
)

-------OR

Day with the max value 2 = 
MAXX (
    INDEX (
        1,
        ADDCOLUMNS (
            SUMMARIZE ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] ),
            "@value", CALCULATE ( SUM ( 'Table'[Value] ) )
        ),
        ORDERBY ( [@value], DESC )
    ),
    [Date]
)

Hi jobf 

Thank you for reaching out to the Microsoft Fabric Forum Community.

Royel Jihwan_Kim Ashish_Mathur danextian Thanks for the inputs

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

Try below 

Max Daily Value =
MAXX (
SUMMARIZE (
Sales,
Sales[Date],
"Total Value", SUM ( Sales[Value] )
),
[Total Value]
)