cancel
Showing results for
Did you mean:
Regular Visitor

## Calculate MAX seems to put MAX value on total line

First time posting but just trying to figure out what im doing wrong here.

MEASURE:

Prior Total Costs =
CALCULATE([Total Costs],
FILTER(ALLSELECTED(Calendar1[Date]),
Calendar1[Date]<= MAX(Calendar1[Prior Plan Year Lookup Date])))

Screenshot:

Need it to return the total between the months not the max value.

2 REPLIES 2
Super User

What exactly are you trying to do?  Explain the question in simple English rather than just pasting a measure.  Show the expected result very clearly.  Share the download link of the PBI file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

@BenBernanke , Grand total is recalculated so it will give the last month in total

You can have a measure like

MEASURE:

Prior Total Costs =
Sumx(Calendar1[Month Year] ) ,  // Assumed month Year is on column
CALCULATE([Total Costs],
FILTER(ALLSELECTED(Calendar1[Date]),
Calendar1[Date]<= MAX(Calendar1[Prior Plan Year Lookup Date])))
)

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors