Forum Discussion
Sum column if another column value is zero
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 ...
Anonymous
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 )
jdbuchanan71
Super User
Super UserAnonymous
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 )
Thank you so much that works!