Count Filter

[tebtim19]

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 the card I am going to, so it will only show the count of regular,student and contractual. 

[v-xicai · Accepted solution]

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]

@tebtim19 , You can filter using visual level filter

or can create a measure like

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