Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Card Total

Hello,

 

Thanks to all who respond.

 

I am using the following in a measure for a card visual:

 

Qty Sales rolling 12 mth =
 CALCULATE(
   SUM ( salesMaster[quantity] ),
       DATESINPERIOD(  
      salesMaster[yearMonth], MAX( salesMaster[yearMonth] ), -12, MONTH))
 
This works fine for all product lines as a grand total.
But I only need to see the quantity for one product line (clutch).
 
How would I add this to my code above to see just the card total for clutch.
 

Thanks!
BLD

 

Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    Anonymous first and foremost, when you are working with dates and using time intelligence functions, always add a date dimension in your model and use that table in your calculations. You can check my video here Learn basics of Time Intelligence DAX functions - Part 1 - YouTube on how to add one and also other time intelligence-related videos. Once it is done, measures are updated, and everything should work.

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    Anonymous first and foremost, when you are working with dates and using time intelligence functions, always add a date dimension in your model and use that table in your calculations. You can check my video here Learn basics of Time Intelligence DAX functions - Part 1 - YouTube on how to add one and also other time intelligence-related videos. Once it is done, measures are updated, and everything should work.

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.