topic Totals in pivot table excluding certain rows under condition in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Totals-in-pivot-table-excluding-certain-rows-under-condition/m-p/3936936#M153105 <P>Hello,</P><P>&nbsp;</P><P>I would like to create a DAX measure which will calculate booking value as sum of ending backlog + sum of shipments - sum of beginning backlog, but only in case there will values of beginning and ending backlog in pivot table. In case there will be only beginning backlog value, then the booking will be 0 or blank. Total value of booking column will be calculated in the same logic - so in case the ending backlog of certain row will be missing, then the whole row will be calculated as 0.</P><P>&nbsp;</P><P>See the printscreen with final expected result I need in Power BI visualisation:</P><P><img /></P><P>&nbsp;</P><P>I enclose dataset below as well.</P><P>&nbsp;</P><P>Thank you very much in advance.</P><P>&nbsp;</P><P>Best regards,</P><P>&nbsp;</P><P>Tomas</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>BeginningBacklog</TD><TD>EndingBacklog</TD><TD>Fiscal_Year</TD><TD>Fiscal_Week_Num</TD><TD>Source</TD><TD>PROD_LINE</TD><TD>&nbsp;Coverage$&nbsp;</TD><TD>ITEM_NUMBER</TD><TD>WAREHOUSE</TD><TD>CUSTOMER_NAME</TD><TD>FY-FW</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47</TD><TD>U1</TD><TD>EMEA</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>T</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,907</TD><TD>T</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 715</TD><TD>S</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,192</TD><TD>S</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,143</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,453</TD><TD>U1</TD><TD>EMEA</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>S</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,430</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,242</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 339</TD><TD>U2</TD><TD>EMEA</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 408</TD><TD>U2</TD><TD>EMEA</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Ending Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 417</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Ending Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,295</TD><TD>T</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Ending Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,988</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Ending Backlog</TD><TD>1760</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,928</TD><TD>Q</TD><TD>APAC</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17,697</TD><TD>U3</TD><TD>APAC</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 332</TD><TD>U3</TD><TD>APAC</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 415</TD><TD>OP</TD><TD>APAC</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27,802</TD><TD>Q</TD><TD>APAC</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>OP</TD><TD>KOREA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16,823</TD><TD>U1</TD><TD>APAC</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 497</TD><TD>OP</TD><TD>EU</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 297</TD><TD>OP</TD><TD>EU</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 276</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1760</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,815</TD><TD>Q</TD><TD>KOREA</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,790</TD><TD>Q</TD><TD>KOREA</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,587</TD><TD>EE</TD><TD>KOREA</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,881</TD><TD>EE</TD><TD>KOREA</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15,431</TD><TD>EE</TD><TD>KOREA</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,017</TD><TD>OP</TD><TD>EU</TD><TD>C5</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 380</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,190</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 669</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 551</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 950</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 69</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 159</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,078</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 950</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 69</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 380</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 159</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 669</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,078</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,190</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 551</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,848</TD><TD>EE</TD><TD>EU</TD><TD>C2</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Shipments</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,319</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 430</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,274</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 734</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,353</TD><TD>EE</TD><TD>EU</TD><TD>C2</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,058</TD><TD>U2</TD><TD>EU</TD><TD>C4</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,331</TD><TD>U1</TD><TD>EU</TD><TD>C4</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,383</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,266</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 380</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,190</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 669</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 551</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 950</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 69</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 159</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,078</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,319</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 430</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,848</TD><TD>EE</TD><TD>EU</TD><TD>C2</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Shipments</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,383</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-21</TD></TR></TBODY></TABLE> Tue, 21 May 2024 18:49:27 GMT tomasjezek 2024-05-21T18:49:27Z Totals in pivot table excluding certain rows under condition https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Totals-in-pivot-table-excluding-certain-rows-under-condition/m-p/3936936#M153105 <P>Hello,</P><P>&nbsp;</P><P>I would like to create a DAX measure which will calculate booking value as sum of ending backlog + sum of shipments - sum of beginning backlog, but only in case there will values of beginning and ending backlog in pivot table. In case there will be only beginning backlog value, then the booking will be 0 or blank. Total value of booking column will be calculated in the same logic - so in case the ending backlog of certain row will be missing, then the whole row will be calculated as 0.</P><P>&nbsp;</P><P>See the printscreen with final expected result I need in Power BI visualisation:</P><P><img /></P><P>&nbsp;</P><P>I enclose dataset below as well.</P><P>&nbsp;</P><P>Thank you very much in advance.</P><P>&nbsp;</P><P>Best regards,</P><P>&nbsp;</P><P>Tomas</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>BeginningBacklog</TD><TD>EndingBacklog</TD><TD>Fiscal_Year</TD><TD>Fiscal_Week_Num</TD><TD>Source</TD><TD>PROD_LINE</TD><TD>&nbsp;Coverage$&nbsp;</TD><TD>ITEM_NUMBER</TD><TD>WAREHOUSE</TD><TD>CUSTOMER_NAME</TD><TD>FY-FW</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47</TD><TD>U1</TD><TD>EMEA</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>T</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,907</TD><TD>T</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 715</TD><TD>S</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,192</TD><TD>S</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,143</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,453</TD><TD>U1</TD><TD>EMEA</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>S</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,430</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,242</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 339</TD><TD>U2</TD><TD>EMEA</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 408</TD><TD>U2</TD><TD>EMEA</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Ending Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 417</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Ending Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,295</TD><TD>T</TD><TD>EMEA</TD><TD>C3</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Ending Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,988</TD><TD>OP</TD><TD>EMEA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Ending Backlog</TD><TD>1760</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,928</TD><TD>Q</TD><TD>APAC</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17,697</TD><TD>U3</TD><TD>APAC</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 332</TD><TD>U3</TD><TD>APAC</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 415</TD><TD>OP</TD><TD>APAC</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27,802</TD><TD>Q</TD><TD>APAC</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>OP</TD><TD>KOREA</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16,823</TD><TD>U1</TD><TD>APAC</TD><TD>C4</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 497</TD><TD>OP</TD><TD>EU</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 297</TD><TD>OP</TD><TD>EU</TD><TD>C5</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 276</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1760</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,815</TD><TD>Q</TD><TD>KOREA</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,790</TD><TD>Q</TD><TD>KOREA</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1759</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,587</TD><TD>EE</TD><TD>KOREA</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Beginning Backlog</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,881</TD><TD>EE</TD><TD>KOREA</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/4/2024</TD><TD>5/11/2024</TD><TD>2024</TD><TD>19</TD><TD>Shipments</TD><TD>1753</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15,431</TD><TD>EE</TD><TD>KOREA</TD><TD>C2</TD><TD>2024-19</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,017</TD><TD>OP</TD><TD>EU</TD><TD>C5</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 380</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,190</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 669</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 551</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 950</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 69</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 159</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,078</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 950</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 69</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 380</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 159</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 669</TD><TD>T</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,078</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,190</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 551</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,848</TD><TD>EE</TD><TD>EU</TD><TD>C2</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Shipments</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,319</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 430</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,274</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 734</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,353</TD><TD>EE</TD><TD>EU</TD><TD>C2</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,058</TD><TD>U2</TD><TD>EU</TD><TD>C4</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,331</TD><TD>U1</TD><TD>EU</TD><TD>C4</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,383</TD><TD>A</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/11/2024</TD><TD>5/18/2024</TD><TD>2024</TD><TD>20</TD><TD>Ending Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,266</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-20</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 380</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,190</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 669</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 551</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 950</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 69</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 159</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,078</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,319</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 430</TD><TD>S</TD><TD>EU</TD><TD>C3</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Beginning Backlog</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,848</TD><TD>EE</TD><TD>EU</TD><TD>C2</TD><TD>2024-21</TD></TR><TR><TD>5/18/2024</TD><TD>5/25/2024</TD><TD>2024</TD><TD>21</TD><TD>Shipments</TD><TD>1752</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,383</TD><TD>B</TD><TD>EU</TD><TD>C1</TD><TD>2024-21</TD></TR></TBODY></TABLE> Tue, 21 May 2024 18:49:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Totals-in-pivot-table-excluding-certain-rows-under-condition/m-p/3936936#M153105 tomasjezek 2024-05-21T18:49:27Z Re: Totals in pivot table excluding certain rows under condition https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Totals-in-pivot-table-excluding-certain-rows-under-condition/m-p/3939144#M153165 <P>Ok,</P><P>&nbsp;</P><P>I solved it eventually...</P><P>&nbsp;</P><DIV><DIV><SPAN>Bookings2 =</SPAN></DIV><BR /><DIV><SPAN>VAR</SPAN> <SPAN>_t</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>ADDCOLUMNS</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>SUMMARIZE</SPAN><SPAN> (</SPAN><SPAN>Append1</SPAN><SPAN>, </SPAN><SPAN>Append1</SPAN><SPAN>[FY-FW]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"@bookings"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN> (</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>[EndBacklog]</SPAN><SPAN>),</SPAN><SPAN>[Shipments]</SPAN><SPAN>,</SPAN><SPAN>[EndBacklog]</SPAN><SPAN>+</SPAN><SPAN>[Shipments]</SPAN><SPAN>-</SPAN><SPAN>[BegBacklog]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>SUMX</SPAN><SPAN> ( </SPAN><SPAN>_t</SPAN><SPAN>, </SPAN><SPAN>[@bookings]</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><DIV><SPAN>...I reused the similar approach like in this topic:</SPAN></DIV><DIV><SPAN><A href="https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Exclude-certain-rows-in-total-with-negative-values/m-p/3776936" target="_blank">https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Exclude-certain-rows-in-total-with-negative-values/m-p/3776936</A></SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>Kudos&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;</SPAN></SPAN></DIV><DIV>&nbsp;</DIV></DIV> Wed, 22 May 2024 10:09:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Totals-in-pivot-table-excluding-certain-rows-under-condition/m-p/3939144#M153165 tomasjezek 2024-05-22T10:09:28Z