Skip to main content
Question

Aggregate the metric's data based on a dimension

  • October 3, 2024
  • 1 reply
  • 49 views

Chahat
Master Helper
Forum|alt.badge.img+14

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.

1 reply

Chahat
Master Helper
Forum|alt.badge.img+14
  • Author
  • Master Helper
  • October 3, 2024

The formula has been resolved now.