Forum Discussion

facilitydax's avatar
facilitydax
Frequent Visitor
6 years ago
Solved

Struggling with a Running Total Measure

I've been struggling with a Running Total measure for a while now.  The problem is that most examples of running total measures that are out there have to do with using a "column" as the sorting mech...
Need Help
  • AlB's avatar
    AlB
    6 years ago

    Hi facilitydax 

    Try this. See it all at work in the attached file.

    Running Total 2 = 
VAR currank2 = [RankTest]
RETURN
    CALCULATE (
        SUMX(Asset; [RM]);
        FILTER(ALL(Asset); [RankTest] <= currank2)
)

     

    Please mark the question solved when done and consider giving kudos if posts are helpful.

    Cheers  Datanaut

facilitydax's avatar
facilitydax
Frequent Visitor
6 years ago

Hi AlB ,

Can't thank you enough for the help so far. It does indeed work in that stripped down troubleshooting file. Unfortunately, I can't verify whether it works in my full larger file model because it exceeds my memory after a minute or so.  It's kind of a bummer because the rank measure and the unconstrainedRM measure render just fine until I try to throw the new running total into the table.

 

If you have any ideas on why it won't finish, give me a holler.

 

Thanks! 

AlB's avatar
AlB
Community Champion
6 years ago

Hard to tell without seeing the real file. Can you show at least the structure of your tables? How many rows do they have? How much memory does your computer have?