Forum Discussion

rosscortb's avatar
rosscortb
Post Patron
7 years ago
Solved

Sum and Divide Calculation

Hello

In Excel this would be Sum(Monthly Overtime) / Annual Salary /12

 

Can you help work this out in DAX please? Answer is 214%

Month OT is £6548

Annual Salary is £36,702

 

I created calculated columns Total Salary and Total Overtime.

I think the problem maybe when I use the month filter as the month filter will show the Month OT but will show the total annual salary. As, the spreadsheet I'm using always just shows annual salary.

Do I need to use the column instead on the measures?

Need anything please ask?

 

Thanks

 

Ross

 

 

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion

     

    rosscortb 

     

    Hi, a calculated columns is not dynamic. So if you want the calcs change with a filter / slicer or context need to use a measure (it's dynamic and calcs with the context)

     

    Regards

     

    Victor