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]))))
amitchandak
Super User
Super UserSomething like this ?
Billable = CALCULATE( DIVIDE(report335[Billable Hours], DIVIDE(report343[Available Hours],DISTINCTCOUNT(report335[User - Name]))))
Thank you amitchandak for the response. Doesnt seem to do the trick since the third argument is an alternate not the new demoniator. If i am understanding that correctly.
Basically i need this in one measure but with table values like i had above.
- 20=billed hours
- 200= available hours
- 4=disctint count on user name
20/(200/4)=4
- amitchandak
Should be something like this
divide(sum(table[billed hours]),(divide(sum(table[available hours]),distinctcount(table[username]))))