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...
You need to make the 'IF' calculation a calculated column for it to work.
Can you please write the full formula including the IF calculated column you mentioned as I am not sure what you mean?
Many thanks
No problem.
So your if statement works fine, you just need to add the previous MEASURE:
Total Vacant SqFt = CALCULATE(SUM(Table[Unit size (sq ft)], Table[Vacant/Used] = "Vacant")
You'll just need to change the items in bold to your specific dataset columns.
If that doesn't work, could you possibly share a pbix file?