Forum Discussion

gdexter's avatar
gdexter
Frequent Visitor
8 years ago
Solved

Cumulative sum IMPOSSIBLE?

Dear Power BI Community,

 

NEED YOUR HELP!

 

I want to create a measure for cumulative total of the EarlyOccurences data (shown below).

I have attempted to use following the DAX formula to create a measure for cumulative total. It doesn't work. What is the problem with it? and what is the right formula to use?

 

Thanks,

Gdexter

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey gdexter

     

    Similar to what jthomson said, you shouldn't have an opening parentheses before the ALL function. The filter should look like:

     

    FILTER(
   ALL('Date'[Daily]),
   'Date'[Daily] <= MAX('Date'[Daily])
)

    Hope this helps,

    Parker

     

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey gdexter

     

    Similar to what jthomson said, you shouldn't have an opening parentheses before the ALL function. The filter should look like:

     

    FILTER(
   ALL('Date'[Daily]),
   'Date'[Daily] <= MAX('Date'[Daily])
)

    Hope this helps,

    Parker

     

     

    • gdexter's avatar
      gdexter
      Frequent Visitor
      8 years ago

      Thanks a lot for the super fast reply! Was in fact too many brackets. I'm new to DAX, had no idea they could mess things up

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        A good trick to follow is that if Intellisense does not allow you to type the function you want, then you either have a syntax error or you can't use the function where you are trying to use it!