topic Re: Sorting and calculating Cumulative value in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3582482#M138210 <P>Hi,</P> <P>I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.</P> <P>Please check the below picture and the attached pbix file.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P><A href="https://learn.microsoft.com/en-us/dax/window-function-dax?wt.mc_id=DP-MVP-5004989" target="_blank">WINDOW function (DAX) - DAX | Microsoft Learn</A></P> <P>&nbsp;</P> <LI-CODE lang="markup">Expected result measure: = CALCULATE ( SUM ( Data[Column B] ), FILTER ( Data, DIVIDE ( CALCULATE ( SUM ( Data[Column B] ), WINDOW ( 1, ABS, 0, REL, SUMMARIZE ( ALL ( Data ), Category[Column A], Data[Column B] ), ORDERBY ( CALCULATE ( SUM ( Data[Column B] ) ), DESC ), DEFAULT, PARTITIONBY ( Category[Column A] ) ) ), CALCULATE ( SUM ( Data[Column B] ), WINDOW ( 1, ABS, -1, ABS, SUMMARIZE ( ALL ( Data ), Category[Column A], Data[Column B] ), ORDERBY ( CALCULATE ( SUM ( Data[Column B] ) ), DESC ), DEFAULT, PARTITIONBY ( Category[Column A] ) ) ) ) &lt;= 0.7 ) ) </LI-CODE> <P>&nbsp;</P> Wed, 13 Dec 2023 17:48:23 GMT Jihwan_Kim 2023-12-13T17:48:23Z Sorting and calculating Cumulative value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3582132#M138188 <P>Hello All,</P><P>&nbsp;</P><P>I have data appearing as below ... i want to sort based on Column A categories and then calculate 70% cumulative value for each category.</P><P>Kindly suggest...</P><TABLE><TBODY><TR><TD>Column A</TD><TD>Column B</TD></TR><TR><TD>TS</TD><TD>2299</TD></TR><TR><TD>TS</TD><TD>919</TD></TR><TR><TD>CL-ACL-QC</TD><TD>2546</TD></TR><TR><TD>CL-ACL-QC</TD><TD>1289</TD></TR><TR><TD>QC</TD><TD>1871</TD></TR><TR><TD>TS</TD><TD>2035</TD></TR><TR><TD>QC</TD><TD>876</TD></TR><TR><TD>TS</TD><TD>1509</TD></TR><TR><TD>QC</TD><TD>3435</TD></TR><TR><TD>TS</TD><TD>1334</TD></TR><TR><TD>CL-ACL-TS</TD><TD>3495</TD></TR><TR><TD>CL-ACL-TS</TD><TD>1600</TD></TR><TR><TD>CL-ACL-QC</TD><TD>1650</TD></TR><TR><TD>TS</TD><TD>1335</TD></TR><TR><TD>CL-ACL-QC</TD><TD>1404</TD></TR><TR><TD>CL-ACL-TS</TD><TD>2434</TD></TR><TR><TD>TS</TD><TD>1762</TD></TR><TR><TD>CL-ACL-TS</TD><TD>1136</TD></TR><TR><TD>TS</TD><TD>1989</TD></TR><TR><TD>TS</TD><TD>1303</TD></TR><TR><TD>CL-ACL-TS</TD><TD>2517</TD></TR><TR><TD>TS</TD><TD>1645</TD></TR><TR><TD>ED TS</TD><TD>2342</TD></TR><TR><TD>ED TS</TD><TD>2186</TD></TR><TR><TD>ED TS</TD><TD>2332</TD></TR><TR><TD>ED TS</TD><TD>1546</TD></TR><TR><TD>ED TS</TD><TD>248</TD></TR><TR><TD>ED TS</TD><TD>1288</TD></TR><TR><TD>ED TS</TD><TD>892</TD></TR><TR><TD>ED PR</TD><TD>3389</TD></TR><TR><TD>ED PR</TD><TD>1789</TD></TR><TR><TD>ED PR</TD><TD>3034</TD></TR><TR><TD>ED PR</TD><TD>3745</TD></TR><TR><TD>ED PR</TD><TD>2820</TD></TR><TR><TD>ED PR</TD><TD>0</TD></TR></TBODY></TABLE> Wed, 13 Dec 2023 14:43:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3582132#M138188 Navin_C 2023-12-13T14:43:54Z Re: Sorting and calculating Cumulative value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3582482#M138210 <P>Hi,</P> <P>I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.</P> <P>Please check the below picture and the attached pbix file.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P><A href="https://learn.microsoft.com/en-us/dax/window-function-dax?wt.mc_id=DP-MVP-5004989" target="_blank">WINDOW function (DAX) - DAX | Microsoft Learn</A></P> <P>&nbsp;</P> <LI-CODE lang="markup">Expected result measure: = CALCULATE ( SUM ( Data[Column B] ), FILTER ( Data, DIVIDE ( CALCULATE ( SUM ( Data[Column B] ), WINDOW ( 1, ABS, 0, REL, SUMMARIZE ( ALL ( Data ), Category[Column A], Data[Column B] ), ORDERBY ( CALCULATE ( SUM ( Data[Column B] ) ), DESC ), DEFAULT, PARTITIONBY ( Category[Column A] ) ) ), CALCULATE ( SUM ( Data[Column B] ), WINDOW ( 1, ABS, -1, ABS, SUMMARIZE ( ALL ( Data ), Category[Column A], Data[Column B] ), ORDERBY ( CALCULATE ( SUM ( Data[Column B] ) ), DESC ), DEFAULT, PARTITIONBY ( Category[Column A] ) ) ) ) &lt;= 0.7 ) ) </LI-CODE> <P>&nbsp;</P> Wed, 13 Dec 2023 17:48:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3582482#M138210 Jihwan_Kim 2023-12-13T17:48:23Z Re: Sorting and calculating Cumulative value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3583753#M138261 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="291628" data-lia-user-login="Jihwan_Kim" class="lia-mention lia-mention-user">Jihwan_Kim</a>&nbsp; Thanks, will test out ...its surely getting closure</P> Thu, 14 Dec 2023 10:42:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3583753#M138261 Navin_C 2023-12-14T10:42:26Z Re: Sorting and calculating Cumulative value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3584021#M138269 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="291628" data-lia-user-login="Jihwan_Kim" class="lia-mention lia-mention-user">Jihwan_Kim</a>&nbsp;<BR /><BR />Attached is my sample data ... I want to sort first based on Q column, then based on Cell2 colum</P><P>n and then pages in descending order. As in excel scrennshot below<BR /><BR /><img /></P><P>&nbsp;</P><P>Then calculate cumulative % for Pages based on above sorting for each category. Kindly refer below.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Q</TD><TD>Cell 2</TD><TD>Pages</TD><TD>Cumulative %</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>5231</TD><TD>8.37%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>4401</TD><TD>15.41%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>4310</TD><TD>22.31%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>4074</TD><TD>28.83%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>3817</TD><TD>34.93%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>3745</TD><TD>40.93%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>3463</TD><TD>46.47%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>3389</TD><TD>51.89%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>3132</TD><TD>56.90%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>3034</TD><TD>61.76%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>2867</TD><TD>66.34%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>2839</TD><TD>70.89%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>2820</TD><TD>75.40%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>2777</TD><TD>79.84%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>2488</TD><TD>83.82%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>2477</TD><TD>87.79%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>2380</TD><TD>91.60%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>1869</TD><TD>94.59%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>1789</TD><TD>97.45%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>1366</TD><TD>99.64%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>228</TD><TD>100.00%</TD></TR><TR><TD>Q1</TD><TD>ED PR</TD><TD>0</TD><TD>100.00%</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>3968</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>3872</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>3428</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>3300</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>3038</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2962</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2810</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2690</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2614</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2348</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2342</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2336</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2332</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2186</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2156</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>2050</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>1958</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>1798</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>1780</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>1770</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>1662</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>1606</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>1546</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>1544</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>ED TS</TD><TD>1518</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>3617</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>3438</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>3433</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>3387</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>3152</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>3122</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>3001</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>2832</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>2829</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>2762</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>2685</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>2683</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>2554</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>2302</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>2203</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>1912</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>1871</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-QC</TD><TD>1323</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2694</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2653</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2648</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2620</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2614</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2589</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2447</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2447</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2414</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2332</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2240</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2225</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2224</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2222</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2194</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2187</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2112</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2102</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2095</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2068</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2035</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>2026</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>1989</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>1923</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>1838</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>1793</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>1762</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>1725</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>1705</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>1668</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>1648</TD><TD>&nbsp;</TD></TR><TR><TD>Q1</TD><TD>XPP-TS</TD><TD>1601</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>3757</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>3137</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>3032</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>2444</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>2443</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>2246</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>2122</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>2049</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>1987</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>1965</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>1791</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>1525</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>1517</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>1517</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED PR</TD><TD>1352</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>2658</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>2210</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>2172</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1812</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1538</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1524</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1264</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1248</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1220</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1198</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1192</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1172</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1140</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1112</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1020</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>1008</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>984</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>828</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>808</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>808</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>808</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>792</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>758</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>ED TS</TD><TD>708</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>5178</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>5122</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>5055</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>5031</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>4139</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>3915</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>3230</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>2978</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>2951</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>2732</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>2583</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>2546</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>2192</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>2099</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-QC</TD><TD>1896</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>2968</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>2910</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>2832</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>2738</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1881</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1502</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1487</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1481</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1478</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1380</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1356</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1330</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1318</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1314</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1265</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1256</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1236</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1198</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1168</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>1145</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>933</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>904</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>829</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>752</TD><TD>&nbsp;</TD></TR><TR><TD>Q2</TD><TD>XPP-TS</TD><TD>424</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>1348</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>924</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>887</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>870</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>868</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>844</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>807</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>797</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>656</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>619</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>490</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>429</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED PR</TD><TD>54</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>933</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>875</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>818</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>751</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>727</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>714</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>701</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>691</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>619</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>606</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>565</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>533</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>526</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>487</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>421</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>407</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>404</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>401</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>391</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>224</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>188</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>178</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>97</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>ED TS</TD><TD>50</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>2339</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>2323</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>2269</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>2048</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>2026</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1952</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1927</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1912</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1742</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1695</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1485</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1423</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1409</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1401</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1383</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1365</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1358</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1351</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1315</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1180</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-QC</TD><TD>1157</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>1386</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>1253</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>1062</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>1048</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>1033</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>1022</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>983</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>964</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>940</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>914</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>896</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>867</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>866</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>864</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>849</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>842</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>841</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>834</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>806</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>802</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>800</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>789</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>788</TD><TD>&nbsp;</TD></TR><TR><TD>Q3</TD><TD>XPP-TS</TD><TD>764</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Thu, 14 Dec 2023 13:19:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3584021#M138269 Navin_C 2023-12-14T13:19:57Z Re: Sorting and calculating Cumulative value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3584466#M138282 <P>Hi,</P> <P>Please check the attached file and the below picture whether it suits your requirement.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">Cumulative % by Q and by Cell: = DIVIDE ( CALCULATE ( SUM ( Data[Pages] ), WINDOW ( 1, ABS, 0, REL, SUMMARIZE ( ALL ( Data ), Q[Q], 'Cell'[Cell 2], Data[Pages] ), ORDERBY ( CALCULATE ( SUM ( Data[Pages] ) ), DESC ), DEFAULT, PARTITIONBY ( Q[Q], 'Cell'[Cell 2] ) ) ), CALCULATE ( SUM ( Data[Pages] ), WINDOW ( 1, ABS, -1, ABS, SUMMARIZE ( ALL ( Data ), Q[Q], 'Cell'[Cell 2], Data[Pages] ), ORDERBY ( CALCULATE ( SUM ( Data[Pages] ) ), DESC ), DEFAULT, PARTITIONBY ( Q[Q], 'Cell'[Cell 2] ) ) ) ) </LI-CODE> Thu, 14 Dec 2023 17:48:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3584466#M138282 Jihwan_Kim 2023-12-14T17:48:44Z Re: Sorting and calculating Cumulative value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3585679#M138332 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="291628" data-lia-user-login="Jihwan_Kim" class="lia-mention lia-mention-user">Jihwan_Kim</a>&nbsp;This worked perfectly !!!</P> Fri, 15 Dec 2023 11:15:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-and-calculating-Cumulative-value/m-p/3585679#M138332 Navin_C 2023-12-15T11:15:02Z