MAXX not calculating consistently

[hailthevine]

Hello, 

I am experiencing an issue where MAXX when combined with a filter is working correctly for some years, but calculates incorrectly on others. See below screenshot. You can see that the Max Demand is reporting as 19.68, but the raw data does not show a day even close to that number.

Here's the DAX I'm using:

Max Day Demand (MGD) =

MAXX(

    KEEPFILTERS(VALUES('Supply Data 21-23'[Days])),

    CALCULATE(SUM('Supply Data 21-23'[Flow (MGD)]))

)

I've checked my data a few times and can't come up with this number.

Thanks in advance!

[Anonymous]

Hi  @hailthevine 

You mentioned that calculates incorrectly on others. Can you explain it in detail ? What is the correct data? I need you to provide your sample before I can determine the cause of the problem.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Community Support Team _ Ailsa Tao

[hailthevine]

Hi Ailsa, 

My data is available at the link below. The correct maximum day for 2021 would be 14.03. The other years' maximum day demand (with the above DAX) calculates correctly. I'm basically adding the flow for each day recorded in Line A and Line B to find the maximum flow day in each year.

Example PBI 

Thanks!