Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

The SUM function only accepts a column reference as an argument.

Loss Ratio = sum(WORK_ADD_OL_DATA[AUTO_LOSS]/SUM(WORK_ADD_OL_DATA[AUTO_EP]))
 
 
Why is this not working ? What should it be instead ? 

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion

    Loss Ratio = sum(WORK_ADD_OL_DATA[AUTO_LOSS])/SUM(WORK_ADD_OL_DATA[AUTO_EP])

  • wdx223_Daniel  Currently I started learning Power BI by doing some beginner level project  which is available from youtube while doing the project I also faced the same problem and found the work around solution for that 

    Try this formula I think It would work because it worked for me 

    Loss Ratio = Divide(sum(WORK_ADD_OL_DATA[AUTO_LOSS]),SUM(WORK_ADD_OL_DATA[AUTO_EP]),0)