Calculate and filter

[Anonymous]

Hi,

So I've a measure that is telling me what current week in Data i have

Actual WW = CALCULATE(MAX(WholeData[WW - Number]),WholeData[Year]="2019")

And then i want to create measure that will be last year YTD 

2018 YTD = CALCULATE(SUM(WholeData[Semi-Net Revenue]),FILTER(WholeData,(WholeData[WW - Number]<=[Actual WW])&& WholeData[Year]="2018"))

and it's returing blank

I found out that "Actual WW" is returning 0 (only in 2018 YTD) but if i will change WholeData[Year]="2018" to "2019" then it does return correct number. 

Any solution? 

[Anonymous · Accepted solution]

I found solution:

2018 YTD =

VAR WWNumber = [Actual WW]

Return

CALCULATE(

SUM(WholeData[Semi-Net Revenue]),

(WholeData[WW - Number]<=WWNumber),

WholeData[Year]="2018"

)