Forum Discussion

5 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    Anonymous add new measure using following DAX

     

    ROI = DIVIDE ( SUM ( COMP[AMT NET_PROFIT_A_TAX_C] ), SUM ( COMP[AMT REVENUE_C] ) )

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Singaravelu_R's avatar
    Singaravelu_R
    Icon for Resolver III rankResolver III
    5 years ago

    Please use this measure ROI:= Divide(AMT NET_PROFIT_A_TAX_C,AMT REVENUE_C,0)

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi All

      Thank you very uch for all your help , it work fine.

      Paul