Forum Discussion
rosscortb
7 years agoPost Patron
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
- VvelardeCommunity Champion
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
- Nathaniel_CCommunity Champion