Forum Discussion

Anonymous

Not applicable

3 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...

3 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})

Impactful Individual

3 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})