Sum Qty With Multiple Criteria in different columns

[MEDSEN]

Hello Comunity, 

Anyone have a solution for this?

On the below Table, I want to sum column "Qty" by distinct "Case ID" for only the the rows that don't have "BOX ID"

BOX ID	CASE ID	Qty	Date
D1		1	1/1/2023
D2	C2	1	1/2/2023
D3	C3	1	1/3/2023
D4	C4	1	1/4/2023
	C5	1	1/5/2023
D6		1	1/6/2023
D7		1	1/7/2023
D8		1	1/8/2023
D9	C9	1	1/9/2023
	C10	1	1/10/2023
D11	C11	1	1/11/2023
D12	C12	1	1/12/2023
D13		1	1/13/2023
D14		1	1/14/2023
	C15	1	1/15/2023
D16	C16	1	1/16/2023
D17	C17	1	1/17/2023
D18	C18	1	1/18/2023
D19	C19	1	1/19/2023

[v-jianboli-msft · Accepted solution]

Hi @MEDSEN ,

Please try:

Measure = CALCULATE(SUM('Table'[Qty]),FILTER('Table','Table'[BOX ID]=BLANK()))

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MEDSEN]

Hello Jianbo Li, 

This is very helpful. Thank you so much for your input.