Need help changing my measure

[RichOB]

Hi, the measures below gives me the total Count for Canada between 01/04/2024 - 30/05/2024 as 3. If I want the combined Total amount instead of the Count, how can this measure be amended so it shows the Total as 95 on a card please?

Canada_Count =
CALCULATE(
COUNT('Sheet1'[Customer_ID]),
'Sheet1'[Country] = "Canada",
'Sheet1'[Date] >= DATE(2024, 4, 1),
'Sheet1'[Date] <= DATE(2024, 4, 30)
)

Customer_ID	Country	Date	Total
1	Canada	01/04/2024	20
2	Canada	02/04/2024	35
3	Canada	04/05/2024	40
4	USA	01/04/2024	35
5	USA	08/05/2024	25
6	UK	03/04/2024	30
7	UK	05/05/2024	40
8	UK	01/06/2024	55
9	UK	06/06/2024	65
10	UK	10/06/2024	35

Thanks!

[Kedar_Pande]

@RichOB 

DAX Measure:

Canada_Total =
CALCULATE (
SUM ( 'Sheet1'[Total] ),
'Sheet1'[Country] = "Canada",
'Sheet1'[Date] >= DATE ( 2024, 4, 1 ),
'Sheet1'[Date] <= DATE ( 2024, 4, 30 )
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[dharmendars007 · Accepted solution]

Hello @RichOB , 

Please use the below measure This measure will now show 95 (the sum of 20, 35, and 40) when used in a card visual for the given date range.

Canada_Total =
CALCULATE(
SUM('Sheet1'[Total]),
'Sheet1'[Country] = "Canada",
'Sheet1'[Date] >= DATE(2024, 4, 1),
'Sheet1'[Date] <= DATE(2024, 5, 30))

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN