Calculate using DAX

[Anonymous]

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	1	$                14,010.44
1	Store2	3	1	$                  9,789.39
1	Store2	1	1	$                28,643.33
1	Store3	2	1	$                14,680.86
1	Store3	3	1	$                12,438.25
1	Store3	1	1	$                41,714.96
1	Store4	2	1	$                  7,908.21
1	Store4	3	1	$                17,931.38
1	Store4	1	1	$                39,634.22
2	Store1	2	1	$                19,838.09
2	Store1	3	1	$                12,786.31
2	Store1	1	1	$                44,042.58
2	Store2	2	1	$                15,187.15
2	Store2	3	1	$                11,641.98
2	Store2	1	1	$                24,876.50
2	Store3	2	1	$                  7,848.64
2	Store3	3	1	$                  9,554.36
2	Store3	1	1	$                20,857.48
2	Store4	2	1	$                  7,537.00
2	Store4	3	1	$                  6,441.51
2	Store4	1	1	$                  8,110.98
3	Store1	2	1	$                20,855.73

there are 52 weeks in column CW for four stores .

Weeding season weeks are-  1,2,3,49,50,51 and 52.

How can I calculate - A measure that calculates the total amount of sales during the Wedding Season.

[v-zhangti]

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.

[Adescrit · Accepted solution]

HI @Anonymous ,

You can try this:

Weeding Season Sales = 
    CALCULATE( SUM('Table'[SaleVolume]) ,'Table'[CW] IN {1, 2, 3, 49, 50, 51, 52})