Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate using DAX

CW StoreID CatID MatID SaleVolume 1 Store1 2 1  $                18,674.64 1 Store1 3 1  $                15,118.37 1 Store1 1 1  $              107,588.30 1 Store2 2...
  • Adescrit's avatar
    Adescrit
    4 years ago

    HI Anonymous ,

     

    You can try this:

    Weeding Season Sales = 
    CALCULATE( SUM('Table'[SaleVolume]) ,'Table'[CW] IN {1, 2, 3, 49, 50, 51, 52})
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

Has your problem been solved, if so, please consider Accept a correct reply as the solution. If not, please provide more details and the output you expect.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.