I'm a little confused on a total column

[Anonymous]

Hi I was wondering if someone can assist. I have a table that has 3 columns adjusted utilization, adjusted billabel hours and expected billable hours. The problem is with Adjusted billable hours. The total is showing 8,389 but the actual total should be 12,861

The formula for Adjusted Billable hours is 

Adjusted Billable Hours = ROUND([Chargeable Hours]+[If Integration Hours]+ [Additional Billable]+ [Pro Bono Rotation],4)

And I have the format to Whole Number 

[Power_Track100]

Hi @Anonymous,
In this case you can use the following DAX=

AdjustedBillable =

VAR ChargeableHours =

CALCULATE(

    SUM(Htable[Chargeable hours]

    )

)

VAR IfIntegration =

CALCULATE(

    SUM(Htable[if Integration ]

    )

)

VAR Additional=

CALCULATE(

    SUM(Htable[Additional Bllable]

    )

)

VAR Bono=

CALCULATE(

    SUM(Htable[Pro Bono]

    )

)

RETURN

ChargeableHours + IfIntegration +Additional + Bono

Remember that calculate is he must powefull function since it could modify the filter context. 
Please adjust the code with you data set.

Hope this help

[Greg_Deckler · Accepted solution]

@Anonymous First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[Anonymous]

Hi @Greg_Deckler

Thank you, however, does this still work if it is not a column but a measure and I'm not able to make it a column. I'm a little confused on how to add  Hasonefilter.

Thanks,
Karrie

[Greg_Deckler]

@Anonymous That solution is specifically for measures, not columns.