cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Sum Qty With Multiple Criteria in different columns

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
1 ACCEPTED SOLUTION
Community Support

Hi @MEDSEN ,

``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.

2 REPLIES 2
Community Support

Hi @MEDSEN ,

``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.

Frequent Visitor

Hello Jianbo Li,

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors