Forum Discussion

marcos_osorio's avatar
marcos_osorio
Helper II
7 years ago
Solved

Problem with SUM

HI, i have a formula who works like this:   TH Total Unit Margin = CALCULATE(SUM('BI Analysis'[Amount])/SUM('BI Analysis'[Qtty]),YEAR('BI Analysis'[DATE RECORD])>2017,'Type of Data'[TYPE] = "Resul...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Use the DIVIDE function, it accounts for a divide by zero error

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Use the DIVIDE function, it accounts for a divide by zero error

marcos_osorio's avatar
marcos_osorio
Helper II
7 years ago

Thank you very much!

I have a lot to learn of Power BI.

Thanks Again!