Forum Discussion

RichOB's avatar
RichOB
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Need 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 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_IDCountryDateTotal
1Canada01/04/202420
2Canada02/04/202435
3Canada04/05/202440
4USA01/04/202435
5USA08/05/202425
6UK03/04/202430
7UK05/05/202440
8UK01/06/202455
9UK06/06/202465
10UK10/06/202435

 

Thanks!

Need Help
Show and Tell
Tips and Tricks
  • dharmendars007's avatar
    dharmendars007
    1 year ago

    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 

2 Replies

  • dharmendars007's avatar
    dharmendars007
    Icon for Memorable Member rankMemorable Member
    1 year ago

    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 

  • Kedar_Pande's avatar
    Kedar_Pande
    Icon for Super User rankSuper User
    1 year ago

    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