Help with the result showing on my card

[Whoule]

Hello,

I want my card to show the sum of the completed column for the latest date available. Here is the data: 

Date	Type	Completed (New)
2021-04-15	Credit	0
2021-04-15	Financial Rejects	50
2021-04-15	Non-Financial Rejects	100
2021-04-15	DQ003	10
2021-04-15	iService	5
2021-05-03	Credit	30
2021-05-03	Financial Rejects	100
2021-05-03	Non-Financial Rejects	200
2021-05-03	DQ003	5
2021-05-03	iService	5
2021-05-17	Credit	100
2021-05-17	Financial Rejects	150
2021-05-17	Non-Financial Rejects	250
2021-05-17	DQ003	2
2021-05-17	iService	5
2021-06-01	Credit	60
2021-06-01	Financial Rejects	40
2021-06-01	Non-Financial Rejects	100
2021-06-01	DQ003	6
2021-06-01	iService	5
2021-06-14	Credit	50
2021-06-14	Financial Rejects	55
2021-06-14	Non-Financial Rejects	100
2021-06-14	DQ003	12
2021-06-14	iService	10

Here is what I do right now but the value showing in my card isnt the right one.

With how I did it, the result showing on my card is 687 while it should show 227 (the sum of the data for the latest date 14-06-2021.

[Jihwan_Kim · Accepted solution]

Hi, @Whoule 

Please check the below picture.

Please try to filter it by Date Column, not by Completed column.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[sayaliredij]

You can create a measure using the following formula and use it as the value in the card. you don't have to put any filters

Last Date Sum =

var maxdate = MAX('Table'[Date ])

RETURN

CALCULATE(SUM('Table'[Completed (New)]),'Table'[Date ] = maxdate)

Thanks,

Sayali

If this post helps, then please consider Accept it as the solution to help others find it more quickly.