Forum Discussion

gottapu's avatar
gottapu
Frequent Visitor
5 years ago
Solved

Need help with DAX calculation

I am new to Power BI and need help with DAX calculation. I have following fields (till Paid Amount) in my report and I am trying to calculate Employee FTE field. Value should be calculated based on Assignment FTE (2 distinct Assignments and so it be .25+.75=1 FTE for Employee 1 and .5 for Employee 2). Seems straight forward but I am unable to get it correct. Appreciate any help.

 

Thanks,

-Raj

Dax Help

2 Replies

    • gottapu's avatar
      gottapu
      Frequent Visitor
      5 years ago

      I am able to calculate accurate values by creating 2 tables but I have few other columns that I need to do the same. Is there a way that I can just include all this in a new column or measure instead of creating 2 tables?

       

      Here is what I did so far:

       

      Creating AssignmentFTE Table

      AssignmentFTETable=summarize(EmployeeTable,EmployeeNumber,AssignmentNumber,AssignmentFTE)

       

      I then created another EmployeeFTE table:

      EmployeeFTETable=summarize(AssignmentFTETable,EmployeeNumber,"EmployeeFTE",sum(AssignmentFTE)

       

      EmployeeFTE is correctly calculated but is there a way I can do all this without creating tables i.e just placing all this logic in a new column? Appreciate any help.

       

      Thanks,

      -Raj