Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Trying to sum full year but getting error message

I have the years selected on a slicer and it am trying to sum full year budget using   full year = CALCULATE(SUM(Budgets[amount]),'Calendar$'[Date].[Year]) but I am receiving this error message. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anyone?

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago
Full Year 2016 =
    CALCULATE (
        SUM ( Budgets[Amount] ),
        FILTER ( ALL ( 'Calendar$' ), 'Calendar$'[Date].[Year] = 2016 )
    )

So if your Slicer is from the Calendar table use the above!

If not this should work either way...

 

Full Year 2016 ALT =
    CALCULATE (
        SUM ( Budgets[Amount] ),
        FILTER ( ALL ( 'Budgets' ), 'Budgets'[budget_code] = 2016 )
    )

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks Sean, will give that a try, take it there is no way to get it to say 2016 automatically?