Forum Discussion

jeralee2's avatar
jeralee2
Frequent Visitor
4 years ago

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 ...
Need Help
jeralee2's avatar
jeralee2
Frequent Visitor
4 years ago

Hi!  I did read through but I noticed a CALCULATE...ALL which from another video I watched, apparently doesn't work anymore with newer versions of PowerBI Desktop.  Maybe you can confirm that for me? 

 

I also don't need to know the percentage as of a point in time.  I only need the number of employees as of today, so a calendar table isn't necessary.  I realize this might throw my calculation off slightly, but we aren't concerned with exacts as we have very low turnover. We just want to know how many trainees actually attended the class vs how many COULD have attended.  

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

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. 

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    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