Forum Discussion

romovaro's avatar
romovaro
Responsive Resident
4 years ago

Formula between 2 columns

Happy Weekend   Quick question. I have the USD column per month and I created a colum called "Risk". Now I want to create a formula   Risk% = (DIVIDE('Weekly Slippage'[Risk], 'Weekly Slippage'[U...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

romovaro can you put Risk % column in the visual? Are these measures or columns?

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.

  • romovaro's avatar
    romovaro
    Responsive Resident
    4 years ago

    Hi Parry2k

     

    Currently 2 measures were created:

     

    Risk = CALCULATE(SUM('Weekly Slippage'[USD]),FILTER ('Weekly Slippage', 'Weekly Slippage'[Project Health] IN {"Red" ,"Orange"}))
     
    Risk% = (DIVIDE('Weekly Slippage'[Risk], 'Weekly Slippage'[USD],0))
    For Risk % i have a column:

     

    And that's the table:

     

     

     

    What I am trying to achieve is to divide TOTAL AMOUN OF USD (all projects) vs the USD amount for the projects with Project health Red and Orange.