Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
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)
Loss Ratio = sum(WORK_ADD_OL_DATA[AUTO_LOSS])/SUM(WORK_ADD_OL_DATA[AUTO_EP])