dax formula to count every entry in your data set for ratio calculations. aka something similar to ALL() function to count entries?

[IloveDeathMEtal]

Employees
[TABLE="width: 500"]
<tbody>[TR]
[TD]bill[/TD]
[/TR]
[TR]
[TD]john[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[/TR]
[TR]
[TD]erin[/TD]
[/TR]
[TR]
[TD]alex[/TD]
[/TR]
[TR]
[TD]john[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[/TR]
</tbody>[/TABLE]

total count of employees=10

is there a dax formula that i can use to count all my employees?

 

[Ozeroth]

The simplest way I can think of is:

Total Count of Employees :=
COUNTROWS ( ALL ( EmployeesTable ) )

This formula would include blank Employees in the count, however.
If that's an issue you could use something like:

Total Count of Nonblank Employees :=
CALCULATE ( COUNTA ( EmployeesTable[Employee] ), ALL ( EmployeesTable ) )

 

[IloveDeathMEtal]

thank you very much ozeroth. this has been the bane of my existence for the past couple of months. lol. worked like a charm.