DAX total help

[SonaSinghA]

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 Offshore])

Month	Onshore	Offshore	SUM	AVG
Jan	123	123	1.0	1.0
Feb	321	198	1.6	1.6
Mar	445	124	3.6	3.6
Apr	567	122	4.6	4.6
Total	1456	567	2.5	2.7

Need to show 10.9 instead of 2.5 Also I need to show Average also.
Please help

[SonaSinghA]

SUMX(EV,DIVIDE([Hours Onshore],[Hours Offshore]))
This is also wrong

[mlsx4]

Hi @SonaSinghA 

Can you explain a bit more what you want to achieve? Which are the conditions?

[SonaSinghA]

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]

Hi @SonaSinghA 

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))