Forum Discussion
Solved
Divide 2 numbers
I have table with two count types - Coaching & Headcount. I am trying to get a measure that will divide ( sum of coaching / sum of headcount) See attached. Example, Under Location...
jcastr02
Add this as a new measure:Measure = DIVIDE( CALCULATE( SUM(Table[Count]), Table[Count Type] = "Coaching"), CALCULATE( SUM(Table[Count]), Table[Count Type] = "Headcount") )________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
jcastr02
Add this as a new measure:
Measure =
DIVIDE(
CALCULATE( SUM(Table[Count]), Table[Count Type] = "Coaching"),
CALCULATE( SUM(Table[Count]), Table[Count Type] = "Headcount")
)________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂