Forum

DAX Formula to Coun...
 
Notifications
Clear all

DAX Formula to Count Employees

6 Posts
2 Users
0 Reactions
79 Views
(@barwicks)
Posts: 7
Active Member
Topic starter
 

Hello,

The Measure I have in does not appear to total up correctly. I am trying get a subtotal the rolls on to each month. Please see attached sample file. 

 
Posted : 08/03/2023 1:27 pm
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

No sample was attached. Try again and don't forget to press "Start upload" before submitting your reply.

 
Posted : 08/03/2023 4:05 pm
(@barwicks)
Posts: 7
Active Member
Topic starter
 

This should have the attachment. 

 
Posted : 08/03/2023 4:57 pm
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

Thanks for the file. And what would be the expected result?

 
Posted : 09/03/2023 2:16 am
(@barwicks)
Posts: 7
Active Member
Topic starter
 

I'm trying to create a measure to count all active employees. Also was trying to get the actual totals for employees by month in the pivot chart, opposed to just the new employees by month that is currently visible. 

 
Posted : 09/03/2023 12:22 pm
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

That I understood, but what would be the end result in the example you posted earlier? Sorry for being slow 🙂

 
Posted : 09/03/2023 5:05 pm
Share: