This content has been marked as final.
Show 2 replies
-
Re: How can I count the total number of distinct recipients that worked a total of 0-20 hours in 2015?
Nicole Smith Apr 4, 2017 11:40 AM (in response to Mohammed Al Radi)Try this (you need to sum the number of hours at the recipient level):
count({<Recipient={'=sum({<Year={2015}>}[Total Hours]) <= 20'}>} distinct Recipient)
If, for some reason, you have negatives or need to include the >=0 portion, you could do so like this:
count({<Recipient={'=sum({<Year={2015}>}[Total Hours]) >= 0'}*{'=sum({<Year={2015}>}[Total Hours]) <= 20'}>} distinct Recipient)
-
Re: How can I count the total number of distinct recipients that worked a total of 0-20 hours in 2015?
Mohammed Al Radi Apr 4, 2017 11:50 AM (in response to Nicole Smith )Amazing! Thanks Nicole
-