Forum Discussion
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 | 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.
HI Anonymous ,
You can try this:
Weeding Season Sales = CALCULATE( SUM('Table'[SaleVolume]) ,'Table'[CW] IN {1, 2, 3, 49, 50, 51, 52})
2 Replies
HI Anonymous ,
You can try this:
Weeding Season Sales = CALCULATE( SUM('Table'[SaleVolume]) ,'Table'[CW] IN {1, 2, 3, 49, 50, 51, 52})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.
