Forum Discussion

tebtim19's avatar
tebtim19
Icon for Helper IV rankHelper IV
6 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
    6 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.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 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.