Forum Discussion

tebtim19's avatar
tebtim19
Icon for Helper IV rankHelper IV
5 years ago
Solved

Count Filter

Is there away I can do the filter remove type of the employee? I have  a table with the list of employee Regular, Student, contractual and Temporary.   I want to remove the Temporary semployee in t...
Need Help
  • v-xicai's avatar
    v-xicai
    5 years ago

    Hi tebtim19 ,

     

    You may create measure like DAX below.

     

     

    Measure1=CALCULATE( COUNTROWS('Table'), ALLEXCEPT('Table', 'Table'[regular], 'Table'[student], 'Table'[contractual] ))

     

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

tebtim19 , You can filter using visual level filter

 

or can create a measure like

 

CALCUALTE([Count of Employee],filter(Table, Table[Type] <> "Temporary"))