Forum Discussion
Count of Measure
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.
Memorable MemberIf 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.
Im unable to add the 'Hrs Grp Category' measure as a column to the matrix table.
- stretcharm
Is hrs group a dax measure?
Try using grouping/binning
https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning
or use a conditional column in M (Query Editor)