Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SUM where multiple values

Hi, 

 

I need to create a calculation whereby I need to sum a value (fact_comp.value) where date.currmonth_offset is in (0, -1, -1, -3, -4, -5, -6, -7, -8, -9, -10, -11, -12, -13)

 

Any idea how I would write out the Dax for this, please?

 

Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    Hey Anonymous ,

     

    sure, you can use that as filter arguments in CALCULATE:

    Sum of Value =
CALCULATE (
    SUM ( fact_comp[value] ),
    date[currmonth_offset] IN { 0, -1, -1, -3, -4, -5, -6, -7, -8, -9, -10, -11, -12, -13 }
)

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

    Best regards
    Denis

    Blog: WhatTheFact.bi
    Follow me: twitter.com/DenSelimovic
     

1 Reply

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    Hey Anonymous ,

     

    sure, you can use that as filter arguments in CALCULATE:

    Sum of Value =
CALCULATE (
    SUM ( fact_comp[value] ),
    date[currmonth_offset] IN { 0, -1, -1, -3, -4, -5, -6, -7, -8, -9, -10, -11, -12, -13 }
)

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

    Best regards
    Denis

    Blog: WhatTheFact.bi
    Follow me: twitter.com/DenSelimovic