Calculate some from a column and a measure

[Anonymous]

Hi I'm trying to calculate the Pro Bono Hours from a Mesuare that calculates the YTD Non-Billable Hours

[ebeery]

@Anonymous can you be a little more clear on what exactly you're trying to achieve, beyond what you're showing in your screenshot?

Do you want to always only want to return the "Pro Bono" category?  If so, using a CALCULATE() function is probably going to be the way to go.

[Anonymous]

Yes, I'm looking for the total of Pro Bono Category

When I start the formula "Calculate(Sum( ", This is where I get stuck the measure "YTD Non-Billable Hours", does not show up. 

[Ashish_Mathur · Accepted solution]

Hi,

The SUM() function taken only a column as an input, not a measure.  Try it like this

=calculate([YTD Non-Billable Hours],