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