Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
Thank you in advance!!
Solved! Go to Solution.
Should be something like this
divide(sum(table[billed hours]),(divide(sum(table[available hours]),distinctcount(table[username]))))
Something 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/(200/4)=4
Should be something like this
divide(sum(table[billed hours]),(divide(sum(table[available hours]),distinctcount(table[username]))))
Hi @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]
)
Proud to be a Super User!
Thank you for the response @danextian. As i said in my question that was underlined, i need it to be in the same measure. Thoughts? Thankyou again for the help!
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |