Forum Discussion
RichOB
Post Partisan
Post PartisanNeed help changing my measure
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 ...
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
Kedar_Pande
Super User
Super UserDAX 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