Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Sum of values based on Employees

Hi team,

 

I am getting the Present (worked days) days of an Employee from the Production sheet for a given month from Distinct count, even for multiple months selection on slicer i am getting the value, but as soon as a new Employee is selected it is showing me a different value.

 

Example : 

Ron12/2/2019
Ron12/3/2019
Ron12/4/2019
Ajay12/2/2019
Ajay12/3/2019
Ajay12/4/2019
Ajay12/5/2019
Ajay12/6/2019

I am getting 3 days for Ron and 5 days for Ajay, but as soon as i select Ron and Ajay both it should give me 3+5 = 8 but showing some other value.

 

Thanks in Advance,

Abhishek

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

If dates are distinct for each employee then you can use count(Table[Date])

 

If not use combine key

Key = [Employee] & [Date] and take a distinct count

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

If dates are distinct for each employee then you can use count(Table[Date])

 

If not use combine key

Key = [Employee] & [Date] and take a distinct count

Anonymous
Not applicable

Thank you! the second option worked for me by combining columns.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.