Forum Discussion
calculate and filter
hello everyone
I have two tables
1.work times.
2.cases from our CRM system
my trying to calculate the sum of the "work time" for each employ and divide it by the number of cases assigned to him.
I have two questions
- if I use calculate function how can I filter it for a single employ
- is it possible to create a measure from two different tables
1 Reply
- jdbuchanan71
Super User
Hello TomBrown ,
What you are trying to do is certainly possible. You should take a look at the intro to DAX course offered by the team at SQLBI. https://www.sqlbi.com/p/introducing-dax-video-course/ It's a good starting place and it is free.
