Forum Discussion
Z-Score in Table Matrix Visual
I am trying to show the Z-Score for each employee in a table matrix. I am using slicers to filter for different zones employees are in. I am not sure how to write the DAX for the following varia...
CountTests = Count(EmployeeData[Tests])
I have 2 tables with much more data than show below, just using these as examples.
Employee Data
| Employee ID | Employee Name |
| 1 | Employee1 |
| 2 | Employee2 |
Test Data
| TestID | Employee ID |
| A13 | Employee1 |
| B34 | Employee1 |
| C43 | Employee1 |
| A13 | Employee2 |
| D56 | Employee2 |
| W43 | Employee3 |
I need to show counts
Employee1 did 3 tests
Employee2 did 1 test
Employee3 did 1 test
//Trythisone Test Count = COUNTROWS( SUMMARIZE('Test Data', 'Test Data'[Employee ID], 'Test Data'[TestID]) )Sorry for the back and forth, I wish there was a way to live chat.
That is giving me the count of test per employee, I need it to return the count of total tests.
Employee1 234 tests
Employee2 221 tests
Employee3 190 tests
Employee4 75 tests
I need the formula to return Total Tests = 720