Forum Discussion

shiv1002's avatar
shiv1002
Regular Visitor
8 years ago
Solved

Calculate percentage based on selection and column value

I need to show the percentage of employees certified as well as not certified based on office selected from a drop-down office selection. I need to show a separate row for each selected office. Below...
  • SivaMani's avatar
    SivaMani
    8 years ago

    shiv1002,

     

    Create two calculated measure using DAX,

     

    Certified = DIVIDE(COUNTX(FILTER(Table1,Table1[Certified ] = "Y"),Table1[Emp Name]),COUNT(Table1[Emp Name]))

     

    Non - Certified = DIVIDE(COUNTX(FILTER(Table1,Table1[Certified ] = "N"),Table1[Emp Name]),COUNT(Table1[Emp Name]))

     

    Hope it will help you:)

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
8 years ago

shiv1002,

 

Create two calculated measure using DAX,

 

Certified = DIVIDE(COUNTX(FILTER(Table1,Table1[Certified ] = "Y"),Table1[Emp Name]),COUNT(Table1[Emp Name]))

 

Non - Certified = DIVIDE(COUNTX(FILTER(Table1,Table1[Certified ] = "N"),Table1[Emp Name]),COUNT(Table1[Emp Name]))

 

Hope it will help you:)