Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter Column X based on Column Y

I have one table that contains the following (example) data.  Approximately 8000 unique Employee IDs, approximately 70,000 total records:   Employee ID Course Title Course Record Status Logge...
  • rubinboer's avatar
    6 years ago

    compares the number of employees that have successfully completed a course vs unsuccessfully or in process

    measures

    number of results = COUNTROWS('YourTable')

    employees that have successfully completed = COUNTROWS(FILTER('YourTable','YourTable'[status] = "Completed_Successfully"))

    employees that have unsuccessfully completed = COUNTROWS(FILTER('YourTable','YourTable'[status] = "Completed_Unsuccessfully"))

    courses that are in progress = COUNTROWS(FILTER('YourTable','YourTable'[status] = "In_Process"))

     

    I need to create a visual that compares

    percentage successfully completed = DIVIDE(employees that have successfully completed , number of results)

    percentage unsuccessfully completed = DIVIDE(employees that have unsuccessfully completed , number of results)

    percentage in progress = DIVIDE(courses that are in progress, number of results)