Forum Discussion
IF Formula issue
Hello, I am working in a real estate dashboard and I am having an issue when I try to create a formula which calculates the total of unit size for the vacant units in the buildings. I am crea...
Hi Marios,
Your calculated column works great on a row by row basis, as each column can be checked to see if vacant or not.
For aggregations, you'll need a measure. Write a new measure along the lines of:
Total SqFt = CALCULATE(SUM(Table[Unit size (sq ft)], Table[Vacant/Used] = "Vacant")
You will need to replace table with the actual table names.
Hope that helps!
Hello JoHo_BI,
Many thanks for your response. I am trying to apply your formula but it cannot accept Table[Vacant/Used] = "Vacant", as in this part of the formula it only accepts measure fields.
Any idea on how to overcome this?