I am trying to consolidate the no. of projects assigned to an employee by below formula:

('Assigned Project'[BY COUNTUNIQUE: 'd. Integer','d. Employee'])
The metric is of dimensions: Project, Integer, employee .
In rows, i have all the dimensions of the metric, but am getting the “1” as the result, and the result is correct if I keep only employees in the rows.
I need to fetch the total no. of projects assigned to an employee. (Metric is having 3 dimensions: Project, Integer, employee ). If an employee has total 4 projects assigned, it should show: “4” as the output for that employee instead of “1” value in each of 4 rows.