Get value from each group based on latest date

[Anonymous]

Hi How to get  Value for each Type based on max date from column End_Date

This should be 2 measure, because will use it in card visual separetely  

Measure1_Open : value 3 , because max date from End_Date = 31 Mar 2022

Measure2_Closed : value 11, because max date from End_Date = 28 Feb 2022

Thank

[Migasuke · Accepted solution]

Hi @Anonymous ,

I think standard CALCULATE should work. Something like:
Measure1_Open = CALCULATE(SUM('Table'[Value]),LATESTDATE('Table'[End_Date]),'Table'[Type]="Open")

The same logic applies for the second measure.

I wrote this on my  phone so if its not working, let me know and I will re-check from my pc.

[Anonymous]

@Migasuke 

It's solved, I modify it a bit

Measure1_Open = CALCULATE(SUM('Table'[Value]),LASTDATE('Table'[End_Date]),'Table'[Type]="Open")

[Anonymous]

@Migasuke 

hmm using LATESTDATE is not working, why use LATESTDATE not MAX?