Forum Discussion

Vegas95's avatar
Vegas95
Regular Visitor
3 years ago
Solved

Dax

 Hi everyone,   My dataset is like this: Account               Date              Value A                          31/12/2022     $200 B                          31/12/2022      $300 C          ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Vegas95 ;

    I've made a little modification here.

    Sum of A + C = CALCULATE(SUM([Value]),FILTER('Table', YEAR([Date])=2022 && ([Account] ="A" || [Account] ="C")))

    Or 

    Sum of A + C = CALCULATE(SUM([Value]),FILTER('Table', YEAR([Date])=2022 && ([Account] in {"A" ,"C"})))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, Vegas95 ;

I've made a little modification here.

Sum of A + C = CALCULATE(SUM([Value]),FILTER('Table', YEAR([Date])=2022 && ([Account] ="A" || [Account] ="C")))

Or 

Sum of A + C = CALCULATE(SUM([Value]),FILTER('Table', YEAR([Date])=2022 && ([Account] in {"A" ,"C"})))

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.