Forum Discussion
Solved
Divide Output of Another Divide in Same DAX Function
Hello All, What i am looking to do is count how many people are in a department (DISTINCTCOUNT) - denominator Then DIVIDE into [Available Hours] - numerator like this Billable = DIVIDE(report3...
Should be something like this
divide(sum(table[billed hours]),(divide(sum(table[available hours]),distinctcount(table[username]))))
danextian
Super User
Super UserHi zsechler ,
You should be able to divide without using a calculate. If your first measure is
Billable =
DIVIDE ( report343[Available Hours], DISTINCTCOUNT ( report335[User - Name] ) )
your second measure would look something like this:
Another Measure =
DIVIDE (
DIVIDE ( <numerator> , <denominator> ),
[Billable]
)