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

MonthOnshoreOffshoreSUMAVG
Jan1231231.01.0
Feb3211981.61.6
Mar4451243.63.6
Apr5671224.64.6
Total14565672.52.7

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

 
Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago
    SUMX(EV,DIVIDE([Hours Onshore],[Hours Offshore]))
    This is also wrong
     
  • mlsx4's avatar
    mlsx4
    Memorable Member
    2 years ago

    Hi Anonymous 

     

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

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