Cumulating by two different variables

Question

Hi!&nbsp;&nbsp;I am creating a cumulative total of value by day. Using this data.&nbsp;&nbsp;I create a quick measure&nbsp;Cumulative total by Day = CALCULATE(&nbsp; &nbsp; SUM('Sheet1'[value]),&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED('Sheet1'[day]),&nbsp; &nbsp; &nbsp; &nbsp; ISONORAFTER('Sheet1'[day], MAX('Sheet1'[day]), DESC)&nbsp; &nbsp; ))&nbsp;And it works.&nbsp;&nbsp;If I use the same DAX measure but show it by 3 day group it doesn't work. I assumed it would work because 3 day group is ordered the same as day. I thought cumulating by day would automatically work over 3 day group, but no.&nbsp;&nbsp;I have to create a new DAX measure to calculate the running total by 3 day group.&nbsp;Cumulative Total by 3 day group = CALCULATE(&nbsp; &nbsp; SUM('Sheet1'[value]),&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED('Sheet1'[3 day group]),&nbsp; &nbsp; &nbsp; &nbsp; ISONORAFTER('Sheet1'[3 day group], MAX('Sheet1'[3 day group]), DESC)&nbsp; &nbsp; ))&nbsp;And that works.&nbsp;&nbsp;Is it possible to do both of these with just one DAX expression? It would be useful not to have to duplicate all my dax measures when I want to cumulate over a different variable.

tharunkumarrtk · Accepted Answer

Newcolator&nbsp;You can follow this pattern:Cumilative = CALCULATE(SUM('Table'[value]), FILTER(ALLSELECTED('Table'[day], 'Table'[3 day group]), 'Table'[day] &lt;= MAX('Table'[day]) &amp;&amp; 'Table'[3 day group] &lt;= MAX('Table'[3 day group])) ) &nbsp;Need Power BI consultation, hire me on UpWork .If the post helps please give a thumbs upIf it solves your issue, please accept it as the solution to help the other members find it more quickly.Tharun

Forum Discussion

Cumulating by two different variables

2 Replies

Related content

Cumulative Difference from Another measure

Cumulative Total

Cumulative difference

Creating Cumulative Graphs

Cumulative Difference with Categorical Variables