Total Column not working

[darraghfarrell]

I created a formula, see below, it looks to be working fine on a row but not when i look at the totals column. 

HardwareCostAmount = SUMX(VALUES(tMobileRevenue[TotalBilled]), DIVIDE(CALCULATE(SUM(tMobileRevenue[TotalBilled])*.95,tMobileRevenue[ChargeType]="XQ"),SUM(tMobileRevenue[ContractTerm])) + DIVIDE(CALCULATE(SUM(tMobileRevenue[TotalBilled]),tMobileRevenue[ChargeType]="XK")*.5,SUM(tMobileRevenue[ContractTerm])))+0

[v-yulgu-msft]

Hi @darraghfarrell,

It's not very clear about your problem according to current desription. Please post sample data and show us the desired output.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu