Forum Discussion

tomperro's avatar
tomperro
Helper V
2 years ago

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...
Need Help
mh2587's avatar
mh2587
Super User
2 years ago
//Trythisone
Test Count = 
COUNTROWS(
    SUMMARIZE('Test Data', 'Test Data'[Employee ID], 'Test Data'[TestID])
)
tomperro's avatar
tomperro
Helper V
2 years ago

mh2587 

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