Forum Discussion
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 the card I am going to, so it will only show the count of regular,student and contractual.
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.
2 Replies
tebtim19 , You can filter using visual level filter
or can create a measure like
CALCUALTE([Count of Employee],filter(Table, Table[Type] <> "Temporary"))
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.
