Dax

Question

&nbsp;Hi everyone,&nbsp;My dataset is like this:Account&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ValueA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31/12/2022&nbsp; &nbsp; &nbsp;$200B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31/12/2022&nbsp; &nbsp; &nbsp; $300C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31/12/2022&nbsp; &nbsp; &nbsp; $100A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31/12/2021&nbsp; &nbsp; &nbsp;$700B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31/12/2021&nbsp; &nbsp; &nbsp; $400C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31/12/2021&nbsp; &nbsp; &nbsp; $200&nbsp;I need to sum, for example, only the values A and C for the 2022. What's the best way or DAX expression to do this?&nbsp;Thanks you for helping me!!

v-yalanwu-msft · Accepted Answer

Hi,&nbsp;Vegas95&nbsp;;
I've made a little modification here.
Sum of A + C = CALCULATE(SUM([Value]),FILTER('Table', YEAR([Date])=2022 &amp;&amp; ([Account] ="A" || [Account] ="C")))
Or&nbsp;
Sum of A + C = CALCULATE(SUM([Value]),FILTER('Table', YEAR([Date])=2022 &amp;&amp; ([Account] in {"A" ,"C"})))
The final show:

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

Forum Discussion

Dax

2 Replies

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DAX