Forum Discussion
Helper IUnderstanding Headcount (Dax for Allexcept, All)
HI anonymoususer92 ,
Thanks rajendraongole1 for the quick reply. I have some other thoughts to add:
1. This is my test data.
2.We can create a column.
EnterBadgeDate = DATEVALUE([EnterBadgeTime])3.We can create a date table.
Date = ADDCOLUMNS(CALENDAR(DATE(2024,1,1),DATE(2024,12,31)),"quarter",QUARTER([Date]),"month",MONTH([Date]),"weeknum",WEEKNUM([Date],2))4. We can create a measure.
UniqueBadgeIns = CALCULATE( DISTINCTCOUNT('Badging Data'[EmployeeID]),ALLSELECTED('Badging Data'))5.Then the result is as follows.
If I've misunderstood you please point it out in a follow-up reply.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi anonymoususer92 ,
Try to:
1. Change the model relationship to a one-to-many relationship in one direction
2. Click the [employee name+id] slicer and set the interaction to "None" on the card visual.Change how visuals interact in a report - Power BI | Microsoft Learn
If that doesn't help, please provide your PBIX file (please note the protection of private data).
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI anonymoususer92 ,
Thanks rajendraongole1 for the quick reply. I have some other thoughts to add:
1. This is my test data.
2.We can create a column.
EnterBadgeDate = DATEVALUE([EnterBadgeTime])
3.We can create a date table.
Date = ADDCOLUMNS(CALENDAR(DATE(2024,1,1),DATE(2024,12,31)),"quarter",QUARTER([Date]),"month",MONTH([Date]),"weeknum",WEEKNUM([Date],2))
4. We can create a measure.
UniqueBadgeIns =
CALCULATE(
DISTINCTCOUNT('Badging Data'[EmployeeID]),ALLSELECTED('Badging Data'))5.Then the result is as follows.
If I've misunderstood you please point it out in a follow-up reply.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IThank you Anonymous Neeko!
This measure works great when I used the data set you provided !
A few points -
1. When I used the above measure on my actual data, it is still giving a count of 3 for 6th of Aug. It is so weird. (See screenshots). And it is the employee with alias name 'D' that is causing this issue. Could this be because I am using another slicer called 'Emp Full + ID' ?
2. Could it be because I changed the relationship between date table (I have a custom date table too) and Badging data to Bi-directional?
3. If you look at your last screenshot, it is showing a count of 3 instead of 2! What do you think happened there?
Hi anonymoususer92 ,
Try to:
1. Change the model relationship to a one-to-many relationship in one direction
2. Click the [employee name+id] slicer and set the interaction to "None" on the card visual.Change how visuals interact in a report - Power BI | Microsoft Learn
If that doesn't help, please provide your PBIX file (please note the protection of private data).
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- anonymoususer92
It worked! The issue I found was that the Sum of Total Minutes had blank values that prevented rows showing up in a table. I changed that in the Power Query from Blank to 0. That seemed to pull up the records on a table.
Let me ask you this now -
If I use the unique badge in measure, I get count (Business Group, Division, even Quarters) as the same value (which is the total unique badge ins). See first image.
But I'd like for it to be like the below image -
Thanks again Neeko!
Hi anonymoususer92 ,
Glad to hear that your issue has been resolved. Sorry for that the information you have provided is not making the problem clear to me.
In order to solve your new problem , please create a new case with a detailed description ,we suggest a case to solve only one problem, because it can get good help and give a better reference for other users!
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.