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 | - |
| 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 |
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 )
2 Replies
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 )Thank you so much that works!