Forum Discussion

Frequent Visitor

7 years ago

Solved

Measure to calculate across rows based on condition

Hi, I have the following dataset. Weeks Sales 1 5 2 12 3 1 4 8 5 9 I want to add weeks 1 and 2 sales to...

7 years ago

Write a measure just to calculate the sum of sales

wk_sales = SUM ( wk_sales[Sales] )

Then you can write a measure to do a running total for the weeks

wk_totaling = 
VAR MaxWk = MAX ( wk_sales[Week] )
RETURN

CALCULATE( [wk_sales],
    FILTER ( ALL ( wk_sales[Week] ) , wk_sales[Week] <= MaxWk ) )

Super User

7 years ago

Write a measure just to calculate the sum of sales

wk_sales = SUM ( wk_sales[Sales] )

Then you can write a measure to do a running total for the weeks

wk_totaling = 
VAR MaxWk = MAX ( wk_sales[Week] )
RETURN

CALCULATE( [wk_sales],
    FILTER ( ALL ( wk_sales[Week] ) , wk_sales[Week] <= MaxWk ) )