Forum Discussion

NutNick1982's avatar
NutNick1982
Icon for Helper I rankHelper I
5 years ago
Solved

Having Trouble with calculating All

Hello Bi Community,

I'm having trouble removing a filter from a calculation.  I want to show YTD values based on the month selected in a slicer and the total values for the current year's budget within the same table. My Calc is:

 

Total Year Budget = CALCULATE(Sum(Budget Values), ALL('Date Table'[Date]), FILTER('Date Table', 'Date Table'[Date].[Year]=YEAR(TODAY())))
 
Hopefully this makes sense...I can provide more information as needed. 
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, NutNick1982 

     

    Please try the below measure.

     

    Total Year Budget =
    CALCULATE (
    SUM ( BudgetVALUES ),
    FILTER ( ALL ( 'Date Table' ), 'Date Table'[Date].[Year] = YEAR ( TODAY () ) )
    )

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, NutNick1982 

     

    Please try the below measure.

     

    Total Year Budget =
    CALCULATE (
    SUM ( BudgetVALUES ),
    FILTER ( ALL ( 'Date Table' ), 'Date Table'[Date].[Year] = YEAR ( TODAY () ) )
    )

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.