Forum Discussion
contribution to whole filtering problem
I have a puzzle that I'm struggling to categorize properly in data modeling terms, as I'm hoping with the right terms, I'll find the right solution. In the simplified diagram below, my tabular mo...
Thanks! The solution ended up being a variation on this, though I will also take a look at the suggested solution re: average across all to see if that could help as well. https://www.youtube.com/watch?v=IfC7gBfod50&feature=youtu.be
Anonymous - You can find the average hours for all of the employees for whatever filters are in context (and specify skill level based on selected employee's skill level) with the following Measure:
Billable Hours (Average) =
var _skill = MAX(Employee[Skill Level])
return CALCULATE(
AVERAGE(WIP[Billable Hours]),
ALL(Employees[Employee Name]),
Employee[Skill Level] = _skill
)I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
I also appreciate Kudos.
Thanks! The solution ended up being a variation on this, though I will also take a look at the suggested solution re: average across all to see if that could help as well. https://www.youtube.com/watch?v=IfC7gBfod50&feature=youtu.be