Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DAX total help

Hello experts, In grand total, Am getting 0 or 1 based on the total offshore and onshore houres. But I need to sum up values from each row. Please help.   FTE = DIVIDE([Hours Onshore],[Hours Offsh...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mlsx4 ,
In grand total, Am getting 0 or 1 based on the total offshore and onshore houres. But I need to sum up values from each row. Please help.

 

FTE = DIVIDE([Hours Onshore],[Hours Offshore])



 

mlsx4's avatar
mlsx4
Memorable Member
2 years ago

Hi Anonymous 

 

How are you doing the table? Formulas are working right for me:

SUM_Col = SUMX(MyTable,DIVIDE(MyTable[Onshore],MyTable[Offshore],0))
AVG_Col = AVERAGEX(MyTable,DIVIDE(MyTable[Onshore],MyTable[Offshore],0))