Count Function

[Flo95]

Hello everyone,

I need a measure for the number of employees of a certain value from a column:

Example: I need a measure with which I can determine the number of "Brandschutzhelfer*in". In the following example, the correct number would be: 3

Mitarbeiter	Rolle
Max Mustermann	Brandschutzhelfer*in
Erika Schuster	Ersthelfer*in
Petra Bauer	Ersthelfer*in
Arnold Frech	Brandschutzhelfer*in
Ulrike Hensler	Abteilungsleiter*in
Olaf Richter	Brandschutzhelfer*in

I tried a Countx function, but it didn't work..

Thanks for your response!

Best regards,

Florian

[Flo95]

@Idrissshatila 

Many thanks, it worked!  

[Idrissshatila · Accepted solution]

HellO @Flo95 ,

try the following 

Count = CALCULATE(COUNTROWS(TableName),'TableName'[Rolle]= "Brandschutzhelfer*in")