Card Total

[Anonymous]

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

[parry2k · Accepted solution]

@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.