Forum Discussion
Solved
Sum of Filtered Values
Hi All, I'm running into one issue with a dashboard I'm building and it's breaking my whole model. First off, I'm dealing with multiple rows of data, each of which is time entry information for v...
I would suggest trying the following change on the Active Working Months measure:
Active Working Months = SUMX( VALUES('Utilization Report'[Employee]), ([Maximum Date]-[Minimum Date])+1)This will mean that if you have 1 employee with 3 months and another with 2 months available at the total/regional levels this will add up to 5 months, then the multiplication by 173 will work
I would suggest trying the following change on the Active Working Months measure:
Active Working Months = SUMX( VALUES('Utilization Report'[Employee]), ([Maximum Date]-[Minimum Date])+1)
This will mean that if you have 1 employee with 3 months and another with 2 months available at the total/regional levels this will add up to 5 months, then the multiplication by 173 will work
You sir are a scholar and a gentleman. That works perfectly! Thank you so much!