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

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.

Reply
onebrady
Regular Visitor

Time calculation changing with a filter applied

I am working with a TimeClock database.  This database tracks Projects performed in an auto repair shop.

 

The employees clock in and clock out of each job.  The "Job"  has a specific code.  Multiple people could login and apply time to any particular job.  The time is registered in the database using a (Time IN) and (Time Out) seperate entry so in order to get the actual time worked on a job I have to calculate the difference between the Time IN and Time Out.

I'm using this DAX in a quick measure
DATEDIFF ( 'EmployeeHours'[TimeIn], 'EmployeeHours'[TimeOut], MINUTE ) / 60.00

 

The problem with this is that I'm trying to create a visual that details which jobs are in progress currently.  When I apply a FILTER to show only those jobs the calculation for All the time applied is only calculated for the resulting data set and no longer includes the total time applied to that specific job.

 

How can I get the totatl time calculation to remain the same regardless of if a filter is applied or not?

 

Before Filter:

 

Before Filter

 

 

After Filter:

After Filter

 

 

1 REPLY 1
v-xjiin-msft
Solution Sage
Solution Sage

Hi @onebrady,

 

Could you please share us your pbix file with One Drive or Google Drive if possible? With current information, it is hard for us to tell where the issue is. Smiley Happy

 

Thanks,
Xi Jin.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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