Forum Discussion
Calculating Percentage Between 2 tables
Hello, I feel like I should know how to do this or find this, but I'm drawing a blank. I have 1 table (Training Log) with records for each employee who has attended a training. It is sorted ...
The ALL function is still working. It's just that REMOVEFILTERS was introduced which is similar to ALL, but perhaps easier to understand out of the box.
If you are calculating % based on TODAY, you won't need the number of days calculation.
Btw, rechecking your employee table by state, you should be using SUM instead of DISTINCTCOUNT.
As regards the attendance table, if the detail is by employee use DISTINCTCOUNT; if the detail is by number of student use SUM