Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate and filter

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's avatar
    Anonymous
    7 years ago

    I found solution:

     

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I found solution:

     

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