Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Can you please share data model, sample data and output expected to find a solution
Cheers
CheenuSing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |