Forum Discussion

Maram's avatar
Maram
Frequent Visitor
9 years ago
Solved

Cumulative Total

Hello.  I am trying to create a cumulative total for each month but I am getting data per month which I don't want to have. I used this measure   Cumulative = CALCULATE( SUM(Finance[Column CC]), ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Filtering all Finance Table (not only a column), I get the Cumulative for the month, but if you have duplicate dates, the cumulative will be the same, in both.

     

    Cumulative = CALCULATE(
    		SUM(Finance[Column CC])
    		,FILTER(ALL(Finance), Finance[Date] <= MAX (Finance[Date])))

     

     

Maram's avatar
Maram
Frequent Visitor
9 years ago

tringuyenminh92 I dont understand why I need to create another date table when I do have one already.

tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

Hi Maram When using All(Original Table) you will lost the filter of another column/categories  in this table. And you have to workaround by using AllExcept to fix that problem. But with seperate Dates table, it will not affect to any filter in Fact table. 

But your question is so great, if I have chance to meet my idol Marco Russo, I will ask him to explain or confirm about my understand of his design in this time pattern: http://www.daxpatterns.com/time-patterns/

 

 

Anonymous I don't think the duplicated(multiple transaction in same date) is the problem with his situation cause he is using filter ALL.