Count of Measure

I need help in creating a measure (on top table) that would calculate the # of employees per category (from bottom table). If possible, I would also like to be able to filter the bottom table with t...

stretcharm
8 years ago
If I'm understanding correctly you can just use group category and account in a matrix to create the top table.
Add distinct employee id count into the value for the matrix. You don't need a new measure drag emp id in and change set the aggregation from the down arrow menu in the values list.
As it's based on the same data it would cross highlight/filter.