Forum Discussion

azakir's avatar
azakir
Icon for Resolver I rankResolver I
4 years ago
Solved

Calculate SUM based on different columns

Hi Guys.   Feels like mental block, but I can't seem to work out a simple sum.    So here's what I am after:  A formula that should give me a sum of the budget based on dates, work oders.  In th...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi azakir 

try

CALCULATE(
    SUM(Table1[Model WO Budget]),
    FILTER(
        ALLSELECTED(Table1[WO_Status_Change_MK_Date])
    )
)


BR

azakir's avatar
azakir
Icon for Resolver I rankResolver I
4 years ago

Thank Anonymous 

But I am getting the following error: 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi azakir ,

    Please try this instead

    CALCULATE(
    SUM(Table1[Model WO Budget]),
        ALLSELECTED(Table1[WO_Status_Change_MK_Date])
)
    • azakir's avatar
      azakir
      Icon for Resolver I rankResolver I
      4 years ago

      Thanks Anonymous 

      The formula worked, and it's giving me a SUM. 

      What I am really after is SUM of "Don't Summarize" Model WO Budget. 

      So for July, it should be 2850+200 = 3050

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        4 years ago

        Hi,

        Share the download link of your PBI file.