Forum Discussion

instdes's avatar
instdes
Frequent Visitor
4 years ago
Solved

Multiplying Values IF Value Exists in One Column

I currently have a measure that multiplies two column numbers together:   Formula = CALCULATE(SUM('Employee'[Effort]) * SUM('Employee'[Completion]))   however sometimes the "Completion" column d...
Need Help
  • instdes's avatar
    instdes
    4 years ago

    Thank you for your response.  Yes, I ended up using this formula:

     

    FormulaNull = CALCULATE(SUM('Employee'[Effort]) * IF(SUM('Employee'[Completion]) = BLANK(), 1, SUM('Employee'[Completion])))
Thingsclump's avatar
Thingsclump
Resolver V
4 years ago

Hi instdes 

 

Did you try using ISBLANK along with IF? If it's blank, return 1. If not, then return actual value.

 

Thanks

 

 

instdes's avatar
instdes
Frequent Visitor
4 years ago

Thank you for your response.  Yes, I ended up using this formula:

 

FormulaNull = CALCULATE(SUM('Employee'[Effort]) * IF(SUM('Employee'[Completion]) = BLANK(), 1, SUM('Employee'[Completion])))