topic Reverse Cumulative Total not working for summarized data(Sum) in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Reverse-Cumulative-Total-not-working-for-summarized-data-Sum/m-p/3039708#M104206 <P>Here i am not using Date column ! I need rever **bleep** value for Revenue based on Column Cutomer_Code and not Date!</P><P>It is working for "Dont Summarize", but when i summarize Revenue as Sum, it gives Wrong Value.</P><P>code :&nbsp;</P><DIV><DIV><SPAN>cum_temp =</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>RunningTotal</SPAN><SPAN>= </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[sum_of_reven]</SPAN><SPAN>, </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>Underlying_Cargo_Analysis</SPAN><SPAN>[Revenue]</SPAN><SPAN>), </SPAN><SPAN>Underlying_Cargo_Analysis</SPAN><SPAN>[Revenue]</SPAN><SPAN>&gt;=</SPAN><SPAN>MIN</SPAN><SPAN>(</SPAN><SPAN>Underlying_Cargo_Analysis</SPAN><SPAN>[Revenue]</SPAN><SPAN>)))</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>[sum_of_reven]</SPAN><SPAN>),</SPAN><SPAN>BLANK</SPAN><SPAN>(),</SPAN><SPAN>RunningTotal</SPAN><SPAN>)</SPAN></DIV></DIV> Tue, 24 Jan 2023 09:20:16 GMT Samarth-Borade 2023-01-24T09:20:16Z Reverse Cumulative Total not working for summarized data(Sum) https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Reverse-Cumulative-Total-not-working-for-summarized-data-Sum/m-p/3039708#M104206 <P>Here i am not using Date column ! I need rever **bleep** value for Revenue based on Column Cutomer_Code and not Date!</P><P>It is working for "Dont Summarize", but when i summarize Revenue as Sum, it gives Wrong Value.</P><P>code :&nbsp;</P><DIV><DIV><SPAN>cum_temp =</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>RunningTotal</SPAN><SPAN>= </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[sum_of_reven]</SPAN><SPAN>, </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>Underlying_Cargo_Analysis</SPAN><SPAN>[Revenue]</SPAN><SPAN>), </SPAN><SPAN>Underlying_Cargo_Analysis</SPAN><SPAN>[Revenue]</SPAN><SPAN>&gt;=</SPAN><SPAN>MIN</SPAN><SPAN>(</SPAN><SPAN>Underlying_Cargo_Analysis</SPAN><SPAN>[Revenue]</SPAN><SPAN>)))</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>[sum_of_reven]</SPAN><SPAN>),</SPAN><SPAN>BLANK</SPAN><SPAN>(),</SPAN><SPAN>RunningTotal</SPAN><SPAN>)</SPAN></DIV></DIV> Tue, 24 Jan 2023 09:20:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Reverse-Cumulative-Total-not-working-for-summarized-data-Sum/m-p/3039708#M104206 Samarth-Borade 2023-01-24T09:20:16Z