Forum Discussion

tlenzmeier's avatar
tlenzmeier
Helper II
8 years ago

Summing Values Based on a Multiplied Value

I am trying to do a cumulative sum based on a value derived from a percentage multiplied by a fixed amount. I need to generate a burnoff of the fixed amount. The attached spreadsheet provides an exam...
Need Help
tlenzmeier's avatar
tlenzmeier
Helper II
8 years ago

Sorry, left out another join: 'Project'[ProjectKey] = 'Burnoff'[ProjectKey].

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi tlenzmeier,

     

    There is only one table in the sample. Can you share a complete sample? Since SUM('Contract'[Amount]) is fixed, I would suggest you use a VAR like below.

    Measure = 
Var total = calculate( SUM('Contract'[Amount]), all(datetable))
    return

    Best Regards,

    Dale