Showing results for 
Search instead for 
Did you mean: 
darraghfarrell Frequent Visitor
Frequent Visitor

Total Column not working

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
Community Support Team
Community Support Team

Re: Total Column not working

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



Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.