Metric for sum based off max date in the week # (time) slicer.

[Anonymous]

Hi, 

I'm trying to get the sum of my inventory based on the maximum  week # from my slicer. 

For example, in the below image: 

• The week #'s range is 34 to 37  
• My Chain + Delivery KPI is $57,258,675
  • This is the sum of all 4 weeks

The Measure I'm trying to make can be seen in the tool bar below as well. 

The metric should report the inventory for only the 37th week, but I'm having a challenge with this one. 

Thank you for any help. 

[speedramps · Accepted solution]

Inventory=
VAR maxweek = MAX( Calendar[week] )

RETURN
CALCULATE(
SUM( Sales[Amount] ),
Calendar[week] = maxweek
)

[Anonymous]

Amazing, thank you!