Measure to display the content of column

[aktripathi2506]

Please consider the following scenario:

I have 3 table they are related to each other by many to one relationship.

I have 3 slicer,

Week

Year

Group

Now I have a measure with the following formula:

(CALCULATE(COUNT(Table1[Emp ID]),FILTER(ALLEXCEPT(Table2,Table2[Year],Table3[Group]),RELATED(Table1[Emp ID]))) - COUNT(Table1[Emp ID]) )

To get the number of employee out of total employee who are not present in the week, year and group name, I chose from the slicer.

For example from group A, for year 2016 and week 38 how many employee are present.

And this formula is working perfectly fine.

The only thing which I am trying now and wondering if that is possible or not is:

If I can get the Emp ID of the employee rather than just the count of employee.

[v-ljerr-msft]

@aktripathi2506

---

The only thing which I am trying now and wondering if that is possible or not is:

If I can get the Emp ID of the employee rather than just the count of employee.

---

Measure operates on aggregations of data defined by the current context, and returns a scalar value. So using a Measure to display the Emp IDs instead of the count of employee is not possible.

Regards

[Anonymous]

@aktripathi2506

Can you please share data model, sample data and output expected to find a solution

Cheers

CheenuSing