Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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. 

 

SFK_Fahim_Kazmi_0-1709133774170.png

This is the measure which i used.

SFK_Fahim_Kazmi_1-1709133900694.png


I have also created relationships

SFK_Fahim_Kazmi_2-1709134125154.png

 


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 4
lbendlin
Super User
Super User

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

Anonymous
Not applicable

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

  SFK_Fahim_Kazmi_0-1709230051916.png

 

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

SFK_Fahim_Kazmi_1-1709230656829.png

Can someone let me know why is this issue coming?

Anonymous
Not applicable

The formula work when i dont apply filter against it.

SFK_Fahim_Kazmi_0-1709231336499.png

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. 

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.