Count of Regular Employee

[tebtim19]

I have tables of all employess with type of regular and temporary,  I want to add a card that it will shows only the count of employee that are regular. Is that possible. 

[amitchandak]

@tebtim19 , Try like

calculate(Count(Table[Empolyee ID]), Table[type]="regular")

or
calculate(Count(Table[Empolyee ID]), filter(Table,Table[type]="regular"))

or
calculate(distinctcount(Table[Empolyee ID]), Table[type]="regular")

[tebtim19]

Hi thanks this is helpful, how about the count of regular male employee only?

[v-diye-msft · Accepted solution]

Hi @tebtim19 

Something like this:

calculate(Count(Table[Empolyee ID]), Table[type]="regular"&&Table[Gender]="male"))

or
calculate(Count(Table[Empolyee ID]), filter(Table,Table[type]="regular"&&Table[Gender]="male"))

or
calculate(distinctcount(Table[Empolyee ID]), Table[type]="regular"&&Table[Gender]="male"))