Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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?

 

JoHo_BI's avatar
JoHo_BI
Icon for Responsive Resident rankResponsive Resident
8 years ago

You need to make the 'IF' calculation a calculated column for it to work.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Can you please write the full formula including the IF calculated column you mentioned as I am not sure what you mean?

     

    Many thanks

    • JoHo_BI's avatar
      JoHo_BI
      Icon for Responsive Resident rankResponsive Resident
      8 years ago

      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?