Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Running Total with categories

Hi all, I have a question on running totals: I have a table "Data" of projects (identified by ID). Each project has a generated power "Power", an operational start year "Op_Year" (in number format -...
Need Help
sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi Anonymous,

 

could you try changing your code to this:

RunningTotal =
CALCULATE (
    SUM ( 'Data'[Power] );
    FILTER (
        ALLEXCEPT ( 'Data'; Data[Geo] );
        'Data'[Op_Year] <= MAX ( 'Data'[Op_Year] )
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi sturlaws, thanks for you reply.
    Unfortunately it does not work . Until I try to categorize the thing it is working as expected (see picture).

     









    When I add "Geo" to the legend of the chart, it changes to this:

     

     

     

     

     

     

     

     

    While what I expect is something like this:

    • Elvi_well's avatar
      Elvi_well
      Frequent Visitor
      1 year ago

      Hi!
      did you solved the problem? I have the same issue.