Measure Effectiveness in %

karelstoel add a new column

 

New Column = DIVIDE ( Table[Cost Column], Table[Invoice Column] )

 

or if you need a measure

 

New Measure  = DIVIDE ( SUM ( Table[Cost Column] ) , SUM ( Table[Invoice Column] ) )

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.⚡

 

Hi karelstoel 

try this,

Measure = MIN('Table'[Gefactureerd])-MIN('Table'[Kosten (incl. AK)])/MIN('Table'[Gefactureerd])

then change the format to percentage

if Gefactureerd & Kosten (incl. AK) are measures, try this,

Measure 2 = [Gefactureerd]-[Kosten (incl. AK)]/[Gefactureerd]

 

if you need more help, please @ me

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.