Sum column if another column value is zero

[kstabler]

Hey, Trying to create a measure of counting QTY of unit types in a building that do not have a patio by correlating my 'QTY of unit types' column with my 'patio SF' column.

4	-
1	-
4	-
1	-
3	87
4	76
1	70
1	264
3	78
1	78
1	78
3	-
6	-
1	-
-	97
4	74
4	74
3	183
1	74

[jdbuchanan71 · Accepted solution]

@kstabler 

Give this a try.  I am assuming you want to sum the amounts in the first column.  You will need to change the table and field names to match your model.

Non-patio units =
CALCULATE ( SUM ( YourTable[Qty of unit types] ), YourTable[Patio SF] = 0 )

[kstabler]

@jdbuchanan71 

Thank you so much that works!