cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LomXof Frequent Visitor
Frequent Visitor

there is any method that can we use to calculate a cumulative sum without referring any dimension

Hi everyone , I just want to calculate a cumulative sum that can work with any filter not only the Time one, I know already the pattern used by Marco Russo, but this one works only when we filter on Date Dimension, has anyone an idea to do this ?

2 REPLIES 2
Super User
Super User

Re: there is any method that can we use to calculate a cumulative sum without referring any dimensio

Can you post sample data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

But, in general you can use something like SUMX(FILTER(ALLSELECTED() or ALLEXCEPT),<filter>),[column])


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: there is any method that can we use to calculate a cumulative sum without referring any dimensio

HI @LomXof,

 

If your tables already contains relationships, you can direct use related columns in current table to apply filter effect.(allselected, values other functions as filter parameter) Otherwise you had to refer other tables.

 

BTW, share some sample data will help for clarify your scenario and code formula.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |