Skip to main content
cancel
Showing results for 
Search instead 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

Reply
BenBernanke
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:
BenBernanke_1-1675123940022.png

 

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


 

 
2 REPLIES 2
Ashish_Mathur
Super User
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
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
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])))
)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.