Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Cumulative Sum for repeated dates

Hello, I created this  Line Graph of Cumulative sum of the data. but the filter on this isnt showing me other projects. I created a measure for this. 

 



This is the measure which i used.


I have also created relationships

 


Even if i choose the filters on the filter page they are not working. Is this becasue of the measure?
beacause i have done filterign with projects on different pages here and they all work but they were all calculated columns. 
If someone knows this, Please let me know. Thank you

 

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Your measure uses ALL() which removes ALL filters. Use a gentler approach like REMOVEFILTERS,  or use CALCULATE to replace specific filters.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      The Cumulative Sum is not showing correct data in the last rows since the month January.

        

       

      This is the formula i'm currently using to calculate the cumulative sum 

      Can someone let me know why is this issue coming?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        The formula work when i dont apply filter against it.

        But when i apply the filter it doesnt work for the measure which i am using to create the Cumulative Sum but it works for the other columns which are being used.