Forum Discussion
Filter Column X based on Column Y
- 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)
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)