Totals in pivot table excluding certain rows under condition

Question

Hello,&nbsp;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.&nbsp;See the printscreen with final expected result I need in Power BI visualisation:&nbsp;I enclose dataset below as well.&nbsp;Thank you very much in advance.&nbsp;Best regards,&nbsp;Tomas&nbsp;BeginningBacklogEndingBacklogFiscal_YearFiscal_Week_NumSourcePROD_LINE&nbsp;Coverage$&nbsp;ITEM_NUMBERWAREHOUSECUSTOMER_NAMEFY-FW5/4/20245/11/2024202419Shipments1759&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;OPEMEAC52024-195/4/20245/11/2024202419Shipments1759&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; 47U1EMEAC42024-195/4/20245/11/2024202419Shipments1759&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;TEMEAC32024-195/4/20245/11/2024202419Shipments1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,907TEMEAC32024-195/4/20245/11/2024202419Shipments1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 715SEMEAC32024-195/4/20245/11/2024202419Shipments1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,192SEMEAC32024-195/4/20245/11/2024202419Shipments1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,143OPEMEAC52024-195/4/20245/11/2024202419Beginning Backlog1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,453U1EMEAC42024-195/4/20245/11/2024202419Shipments1759&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;SEMEAC32024-195/4/20245/11/2024202419Shipments1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,430OPEMEAC52024-195/4/20245/11/2024202419Shipments1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,242OPEMEAC52024-195/4/20245/11/2024202419Shipments1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 339U2EMEAC42024-195/4/20245/11/2024202419Shipments1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 408U2EMEAC42024-195/4/20245/11/2024202419Ending Backlog1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 417OPEMEAC52024-195/4/20245/11/2024202419Ending Backlog1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,295TEMEAC32024-195/4/20245/11/2024202419Ending Backlog1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,988OPEMEAC52024-195/4/20245/11/2024202419Ending Backlog1760&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,928QAPACC22024-195/4/20245/11/2024202419Shipments1753&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17,697U3APACC42024-195/4/20245/11/2024202419Shipments1753&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 332U3APACC42024-195/4/20245/11/2024202419Shipments1753&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 415OPAPACC52024-195/4/20245/11/2024202419Shipments1753&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27,802QAPACC22024-195/4/20245/11/2024202419Shipments1753&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;OPKOREAC52024-195/4/20245/11/2024202419Shipments1753&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16,823U1APACC42024-195/4/20245/11/2024202419Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 497OPEUC52024-195/4/20245/11/2024202419Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 297OPEUC52024-195/4/20245/11/2024202419Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 276AEUC12024-195/4/20245/11/2024202419Beginning Backlog1760&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,815QKOREAC22024-195/4/20245/11/2024202419Beginning Backlog1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,790QKOREAC22024-195/4/20245/11/2024202419Beginning Backlog1759&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,587EEKOREAC22024-195/4/20245/11/2024202419Beginning Backlog1753&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,881EEKOREAC22024-195/4/20245/11/2024202419Shipments1753&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15,431EEKOREAC22024-195/11/20245/18/2024202420Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,017OPEUC52024-205/11/20245/18/2024202420Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 380TEUC32024-205/11/20245/18/2024202420Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,190TEUC32024-205/11/20245/18/2024202420Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 669TEUC32024-205/11/20245/18/2024202420Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 551SEUC32024-205/11/20245/18/2024202420Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 950AEUC12024-205/11/20245/18/2024202420Beginning Backlog1752&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; 69BEUC12024-205/11/20245/18/2024202420Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 159SEUC32024-205/11/20245/18/2024202420Beginning Backlog1752&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; 8SEUC32024-205/11/20245/18/2024202420Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,078SEUC32024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 950AEUC12024-205/11/20245/18/2024202420Ending Backlog1752&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; 69AEUC12024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 380TEUC32024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 159TEUC32024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 669TEUC32024-205/11/20245/18/2024202420Ending Backlog1752&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; 8SEUC32024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,078SEUC32024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,190SEUC32024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 551SEUC32024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,848EEEUC22024-205/11/20245/18/2024202420Shipments1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,319AEUC12024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 430SEUC32024-205/11/20245/18/2024202420Ending Backlog1752&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; 12SEUC32024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,274SEUC32024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 734SEUC32024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,353EEEUC22024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,058U2EUC42024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,331U1EUC42024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,383AEUC12024-205/11/20245/18/2024202420Ending Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,266BEUC12024-205/18/20245/25/2024202421Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 380SEUC32024-215/18/20245/25/2024202421Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,190SEUC32024-215/18/20245/25/2024202421Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 669SEUC32024-215/18/20245/25/2024202421Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 551SEUC32024-215/18/20245/25/2024202421Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 950BEUC12024-215/18/20245/25/2024202421Beginning Backlog1752&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; 69BEUC12024-215/18/20245/25/2024202421Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 159SEUC32024-215/18/20245/25/2024202421Beginning Backlog1752&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; 8SEUC32024-215/18/20245/25/2024202421Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,078SEUC32024-215/18/20245/25/2024202421Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,319BEUC12024-215/18/20245/25/2024202421Beginning Backlog1752&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; 12SEUC32024-215/18/20245/25/2024202421Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 430SEUC32024-215/18/20245/25/2024202421Beginning Backlog1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,848EEEUC22024-215/18/20245/25/2024202421Shipments1752&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,383BEUC12024-21

tomasjezek · Accepted Answer

Ok,&nbsp;I solved it eventually...&nbsp;Bookings2 =VAR _t = &nbsp; &nbsp; ADDCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE (Append1, Append1[FY-FW]),&nbsp; &nbsp; &nbsp; &nbsp; "@bookings",&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (ISBLANK([EndBacklog]),[Shipments],[EndBacklog]+[Shipments]-[BegBacklog])&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )RETURN&nbsp; &nbsp; SUMX ( _t, [@bookings])&nbsp;&nbsp;...I reused the similar approach like in this topic:https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Exclude-certain-rows-in-total-with-negative-values/m-p/3776936&nbsp;Kudos&nbsp;Jihwan_Kim&nbsp;&nbsp;

Forum Discussion

Totals in pivot table excluding certain rows under condition

1 Reply

Related content

Help Calculating Average Excluding 2 Conditions

Calculation excluding condition

Drill through excluding specific record

Rank with conditions

Conditional Formatting using DAX

BeginningBacklog	EndingBacklog	Fiscal_Year	Fiscal_Week_Num	Source	PROD_LINE	Coverage$	ITEM_NUMBER	WAREHOUSE	CUSTOMER_NAME	FY-FW
5/4/2024	5/11/2024	2024	19	Shipments	1759	-	OP	EMEA	C5	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	47	U1	EMEA	C4	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	-	T	EMEA	C3	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	1,907	T	EMEA	C3	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	715	S	EMEA	C3	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	1,192	S	EMEA	C3	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	1,143	OP	EMEA	C5	2024-19
5/4/2024	5/11/2024	2024	19	Beginning Backlog	1759	8,453	U1	EMEA	C4	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	-	S	EMEA	C3	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	7,430	OP	EMEA	C5	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	3,242	OP	EMEA	C5	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	339	U2	EMEA	C4	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1759	408	U2	EMEA	C4	2024-19
5/4/2024	5/11/2024	2024	19	Ending Backlog	1759	417	OP	EMEA	C5	2024-19
5/4/2024	5/11/2024	2024	19	Ending Backlog	1759	7,295	T	EMEA	C3	2024-19
5/4/2024	5/11/2024	2024	19	Ending Backlog	1759	8,988	OP	EMEA	C5	2024-19
5/4/2024	5/11/2024	2024	19	Ending Backlog	1760	1,928	Q	APAC	C2	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1753	17,697	U3	APAC	C4	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1753	332	U3	APAC	C4	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1753	415	OP	APAC	C5	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1753	27,802	Q	APAC	C2	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1753	-	OP	KOREA	C5	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1753	16,823	U1	APAC	C4	2024-19
5/4/2024	5/11/2024	2024	19	Beginning Backlog	1752	497	OP	EU	C5	2024-19
5/4/2024	5/11/2024	2024	19	Beginning Backlog	1752	297	OP	EU	C5	2024-19
5/4/2024	5/11/2024	2024	19	Beginning Backlog	1752	276	A	EU	C1	2024-19
5/4/2024	5/11/2024	2024	19	Beginning Backlog	1760	7,815	Q	KOREA	C2	2024-19
5/4/2024	5/11/2024	2024	19	Beginning Backlog	1759	1,790	Q	KOREA	C2	2024-19
5/4/2024	5/11/2024	2024	19	Beginning Backlog	1759	6,587	EE	KOREA	C2	2024-19
5/4/2024	5/11/2024	2024	19	Beginning Backlog	1753	8,881	EE	KOREA	C2	2024-19
5/4/2024	5/11/2024	2024	19	Shipments	1753	15,431	EE	KOREA	C2	2024-19
5/11/2024	5/18/2024	2024	20	Beginning Backlog	1752	2,017	OP	EU	C5	2024-20
5/11/2024	5/18/2024	2024	20	Beginning Backlog	1752	380	T	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Beginning Backlog	1752	1,190	T	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Beginning Backlog	1752	669	T	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Beginning Backlog	1752	551	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Beginning Backlog	1752	950	A	EU	C1	2024-20
5/11/2024	5/18/2024	2024	20	Beginning Backlog	1752	69	B	EU	C1	2024-20
5/11/2024	5/18/2024	2024	20	Beginning Backlog	1752	159	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Beginning Backlog	1752	8	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Beginning Backlog	1752	1,078	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	950	A	EU	C1	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	69	A	EU	C1	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	380	T	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	159	T	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	669	T	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	8	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	1,078	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	1,190	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	551	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	1,848	EE	EU	C2	2024-20
5/11/2024	5/18/2024	2024	20	Shipments	1752	1,319	A	EU	C1	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	430	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	12	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	1,274	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	734	S	EU	C3	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	1,353	EE	EU	C2	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	1,058	U2	EU	C4	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	1,331	U1	EU	C4	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	1,383	A	EU	C1	2024-20
5/11/2024	5/18/2024	2024	20	Ending Backlog	1752	1,266	B	EU	C1	2024-20
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	380	S	EU	C3	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	1,190	S	EU	C3	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	669	S	EU	C3	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	551	S	EU	C3	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	950	B	EU	C1	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	69	B	EU	C1	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	159	S	EU	C3	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	8	S	EU	C3	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	1,078	S	EU	C3	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	1,319	B	EU	C1	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	12	S	EU	C3	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	430	S	EU	C3	2024-21
5/18/2024	5/25/2024	2024	21	Beginning Backlog	1752	1,848	EE	EU	C2	2024-21
5/18/2024	5/25/2024	2024	21	Shipments	1752	1,383	B	EU	C1	2024-21