cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent 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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.