Forum Discussion
How to get Available Distinct Employee(Dimension) Vs Distinct Employee (Fact) comparison
Hi,
I have 2 tables:
Employee Dim
Training Fact
joining condition: employeeid
Employee Dim has the list of all the employees in the organization (220k) while in Training Fact can be a subset, where around 120k employeed have taken certain training. While I am trying to compare the number of total employee vs employee who has taken training, both the numbers are showing same (maybe due to the joins). Below is the number
Unique User Total = COUNT(BU_Ext[employee_id])
Unique User = distinctCOUNT(SumTotal_Fact[Employee ID])
The number under the total is getting reduced to the number of matching employee with fact.
How can I resolve this??
Anonymous ,
try this for Unique User Total,
Unique users = CALCULATE( COUNT(BU_Ext[employee_id]),ALL(BU_Ext))Thanks,
Arul
3 Replies
Anonymous ,
try this for Unique User Total,
Unique users = CALCULATE( COUNT(BU_Ext[employee_id]),ALL(BU_Ext))Thanks,
Arul