Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
ajitsahoo8338
Helper III
Helper III

I need some with one logic

‎11-25-2024 08:37 PM

Hello Everyone I need help with one logic. My Data looks like this.

Employee NameDateWork Hours
David 11/18/2024      8
David 11/19/2024      8
David 11/20/2024      8
David 11/21/2024      8
David 11/22/2024      0

My requirement is to create a measure or calculated column. The logic would be: If Work Hours = 8, then Work Hours; if Work Hours>8, then 8. 
I tried this below DAX.

IF(SUM(Employee_Hrs[Work Hours])<=8,SUM(Employee_Hrs[Work Hours]),8). 
The logic is working correctly but the total is not.

 
Employee NameDateWork HoursNew Measure
David 11/18/2024     8   8
David 11/19/2024     8   8
David 11/20/2024     8   8
David 11/21/2024     8   8
David 11/22/2024    0   0
Total    32   8
Please help with this one.
Labels:
Message 1 of 13
465 Views
0
12 REPLIES 12
mussaenda
Super User
Super User

‎11-26-2024 01:10 AM

Hi @ajitsahoo8338 ,

 

Why don't we create a calculated column for the logic that you need, then aggregate them using a measure?

 

Would that work for you?

Message 13 of 13
339 Views
0
Kedar_Pande
Super User
Super User

‎11-25-2024 10:10 PM

@ajitsahoo8338 

Correct Measure

New Measure =
SUMX(
Employee_Hrs,
IF(Employee_Hrs[Work Hours] <= 8, Employee_Hrs[Work Hours], 😎
)

This approach ensures that the total reflects the sum of the individual row calculations.

 

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

Message 11 of 13
380 Views
0
ajitsahoo8338
Helper III
Helper III
In response to Kedar_Pande

‎11-25-2024 10:49 PM

Hello @Kedar_Pande This works but If add a date slicer then it is not working. Can you please try this below using a date slicer

EmployeeDateWork Hours
Amy3/11/2024 0:008
Amy3/12/2024 0:008
Amy3/13/2024 0:008
Amy3/14/2024 0:008
Amy3/15/2024 0:008
Amy3/18/2024 0:008
Amy3/19/2024 0:008
Amy3/20/2024 0:008
Amy3/21/2024 0:008
Amy3/22/2024 0:008
Amy3/25/2024 0:008
Amy3/26/2024 0:009
Amy3/27/2024 0:008
Amy3/28/2024 0:008
Amy3/29/2024 0:008.5
Amy4/1/2024 0:008.5
Amy4/2/2024 0:008
Amy4/3/2024 0:0010.5
Amy4/4/2024 0:008.5
Amy4/5/2024 0:008.5
Amy4/8/2024 0:006.5
Amy4/9/2024 0:008.5
Amy4/10/2024 0:009
Amy4/11/2024 0:0010
Amy4/12/2024 0:008
Amy4/15/2024 0:009
Amy4/16/2024 0:009
Amy4/17/2024 0:009
Amy4/18/2024 0:007
Amy4/19/2024 0:007.5
Amy4/22/2024 0:009.5
Amy4/23/2024 0:009
Amy4/24/2024 0:008
Amy4/25/2024 0:007
Amy4/26/2024 0:008
Amy4/29/2024 0:009
Amy4/30/2024 0:007.5
Amy5/1/2024 0:008
Amy5/2/2024 0:008
Amy5/3/2024 0:008
Amy5/6/2024 0:008
Amy5/7/2024 0:007
Amy5/8/2024 0:008.5
Amy5/9/2024 0:008.5
Amy5/10/2024 0:008
Amy5/13/2024 0:008
Amy5/14/2024 0:009
Amy5/15/2024 0:008.5
Amy5/16/2024 0:008.5
Amy5/17/2024 0:008
Amy5/20/2024 0:009
Amy5/21/2024 0:008
Amy5/22/2024 0:008
Amy5/23/2024 0:008
Amy5/24/2024 0:008
Amy5/27/2024 0:008
Amy5/28/2024 0:008
Amy5/29/2024 0:008
Amy5/30/2024 0:009
Amy5/31/2024 0:008
Amy6/3/2024 0:008.5
Amy6/4/2024 0:008
Amy6/5/2024 0:0012.5
Amy6/6/2024 0:006
Amy6/7/2024 0:008
Amy6/10/2024 0:008
Amy6/11/2024 0:008.5
Amy6/12/2024 0:008
Amy6/13/2024 0:008
Amy6/14/2024 0:008
Amy6/17/2024 0:008
Amy6/18/2024 0:007.5
Amy6/19/2024 0:007.5
Amy6/20/2024 0:008
Amy6/21/2024 0:008.5
Amy6/24/2024 0:008
Amy6/25/2024 0:008
Amy6/26/2024 0:008.5
Amy6/27/2024 0:008
Amy6/28/2024 0:008.5
Amy7/1/2024 0:008
Amy7/2/2024 0:008
Amy7/3/2024 0:008
Amy7/4/2024 0:008
Amy7/5/2024 0:008
Amy7/8/2024 0:008
Amy7/9/2024 0:008
Amy7/10/2024 0:008
Amy7/11/2024 0:008
Amy7/12/2024 0:008
Amy7/15/2024 0:008.5
Amy7/16/2024 0:008.5
Amy7/17/2024 0:008
Amy7/18/2024 0:007.5
Amy7/19/2024 0:007.5
Amy7/22/2024 0:008.8
Amy7/23/2024 0:008
Amy7/24/2024 0:008
Amy7/25/2024 0:006.2
Amy7/26/2024 0:008
Amy7/29/2024 0:008
Amy7/30/2024 0:008
Amy7/31/2024 0:008
Amy8/1/2024 0:008
Amy8/2/2024 0:008
Amy8/5/2024 0:008
Amy8/6/2024 0:008
Amy8/7/2024 0:008
Amy8/8/2024 0:008
Amy8/9/2024 0:008
Amy8/12/2024 0:008
Amy8/13/2024 0:009
Amy8/14/2024 0:009.8
Amy8/15/2024 0:0010
Amy8/16/2024 0:008
Amy8/19/2024 0:008
Amy8/20/2024 0:007
Amy8/21/2024 0:009
Amy8/22/2024 0:008
Amy8/23/2024 0:008
Amy8/26/2024 0:008
Amy8/27/2024 0:008
Amy8/28/2024 0:008
Amy8/29/2024 0:008
Amy8/30/2024 0:008
Amy9/2/2024 0:008
Amy9/3/2024 0:008
Amy9/4/2024 0:008
Amy9/5/2024 0:008
Amy9/6/2024 0:009
Amy9/9/2024 0:007
Amy9/10/2024 0:008.5
Amy9/11/2024 0:008
Amy9/12/2024 0:007
Amy9/13/2024 0:009
Amy9/16/2024 0:008
Amy9/17/2024 0:008.5
Amy9/18/2024 0:008
Amy9/19/2024 0:007.5
Amy9/20/2024 0:008
Amy9/23/2024 0:007.5
Amy9/24/2024 0:008.5
Amy9/25/2024 0:008
Amy9/26/2024 0:008
Amy9/27/2024 0:008
Amy9/30/2024 0:008
Amy10/1/2024 0:008
Amy10/2/2024 0:008
Amy10/3/2024 0:008
Amy10/4/2024 0:008
Amy10/7/2024 0:009.5
Amy10/8/2024 0:007.5
Amy10/9/2024 0:008.5
Amy10/10/2024 0:008
Amy10/11/2024 0:007
Amy10/14/2024 0:007.5
Amy10/15/2024 0:008
Amy10/16/2024 0:008.5
Amy10/17/2024 0:008
Amy10/18/2024 0:008
Amy10/21/2024 0:008
Amy10/22/2024 0:008
Amy10/23/2024 0:008
Amy10/24/2024 0:008
Amy10/25/2024 0:008
Amy10/28/2024 0:007.5
Amy10/29/2024 0:008
Amy10/30/2024 0:008.5
Amy10/31/2024 0:008
Amy11/1/2024 0:008
Amy11/4/2024 0:008
Amy11/5/2024 0:008
Amy11/6/2024 0:008
Amy11/7/2024 0:008.5
Amy11/8/2024 0:008
Amy11/11/2024 0:008.2
Amy11/12/2024 0:008
Amy11/13/2024 0:008
Amy11/14/2024 0:008
Amy11/15/2024 0:008
Amy11/18/2024 0:007
Amy11/19/2024 0:0010
Amy11/20/2024 0:008.5
Amy11/21/2024 0:008
Amy11/22/2024 0:008
Amy11/25/2024 0:008
Amy11/26/2024 0:008
Amy11/27/2024 0:008
Amy11/28/2024 0:008
Amy11/29/2024 0:008
Message 12 of 13
372 Views
0
Suresh604
Frequent Visitor

‎11-25-2024 09:20 PM

Hi @ajitsahoo8338 , 
You can follow the below step:

  1. Create a Measure in Power BI:

    • Open your Power BI file and go to the "Modeling" tab.
    • Click on "New Measure" to create a new measure.

  2. Write the Correct DAX Formula:

    • Use the following DAX formula for your new measure:
      New Measure = SUMX(Employee_Hrs, IF(Employee_Hrs[Work Hours] <= 8, Employee_Hrs[Work Hours], 8))
    • This formula goes through each row and applies the logic you want: if the work hours are 8 or less, it takes the actual work hours; if they are more than 8, it caps them at 8.

Explanation:

  • SUMX: This function calculates the sum of an expression for each row in a table.
  • IF Condition: It checks each row if the work hours are 8 or less and applies the appropriate logic.

Result:

This measure will ensure that each row is calculated correctly and that the total reflects the sum of these calculations. Your data and results should now look like this:

Employee Name Date Work Hours New Measure

David11/18/202488
David11/19/202488
David11/20/202488
David11/21/202488
David11/22/202400
Total 3232

Now, the total of the "New Measure" column should correctly add up to 32, reflecting the sum of each individual row calculation.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Suresh Patra
https://www.linkedin.com/in/sureshpatra

Message 7 of 13
424 Views
0
ajitsahoo8338
Helper III
Helper III
In response to Suresh604

‎11-25-2024 09:31 PM

Hello @Suresh604 

Thank you for your response. This is not working when the date filter is applied. Please check below.

ajitsahoo8338_0-1732599082120.png

 

Message 8 of 13
398 Views
0
Suresh604
Frequent Visitor
In response to ajitsahoo8338

‎11-26-2024 12:38 AM

Hey @ajitsahoo8338 , Can you please check with your data model or the relationship? 

Message 10 of 13
344 Views
0
ajitsahoo8338
Helper III
Helper III
In response to ajitsahoo8338

‎11-25-2024 10:50 PM

Hello @Suresh604 This works but If add a date slicer then it is not working. Can you please try this below using a date slicer

EmployeeDateWork Hours
Amy3/11/2024 0:008
Amy3/12/2024 0:008
Amy3/13/2024 0:008
Amy3/14/2024 0:008
Amy3/15/2024 0:008
Amy3/18/2024 0:008
Amy3/19/2024 0:008
Amy3/20/2024 0:008
Amy3/21/2024 0:008
Amy3/22/2024 0:008
Amy3/25/2024 0:008
Amy3/26/2024 0:009
Amy3/27/2024 0:008
Amy3/28/2024 0:008
Amy3/29/2024 0:008.5
Amy4/1/2024 0:008.5
Amy4/2/2024 0:008
Amy4/3/2024 0:0010.5
Amy4/4/2024 0:008.5
Amy4/5/2024 0:008.5
Amy4/8/2024 0:006.5
Amy4/9/2024 0:008.5
Amy4/10/2024 0:009
Amy4/11/2024 0:0010
Amy4/12/2024 0:008
Amy4/15/2024 0:009
Amy4/16/2024 0:009
Amy4/17/2024 0:009
Amy4/18/2024 0:007
Amy4/19/2024 0:007.5
Amy4/22/2024 0:009.5
Amy4/23/2024 0:009
Amy4/24/2024 0:008
Amy4/25/2024 0:007
Amy4/26/2024 0:008
Amy4/29/2024 0:009
Amy4/30/2024 0:007.5
Amy5/1/2024 0:008
Amy5/2/2024 0:008
Amy5/3/2024 0:008
Amy5/6/2024 0:008
Amy5/7/2024 0:007
Amy5/8/2024 0:008.5
Amy5/9/2024 0:008.5
Amy5/10/2024 0:008
Amy5/13/2024 0:008
Amy5/14/2024 0:009
Amy5/15/2024 0:008.5
Amy5/16/2024 0:008.5
Amy5/17/2024 0:008
Amy5/20/2024 0:009
Amy5/21/2024 0:008
Amy5/22/2024 0:008
Amy5/23/2024 0:008
Amy5/24/2024 0:008
Amy5/27/2024 0:008
Amy5/28/2024 0:008
Amy5/29/2024 0:008
Amy5/30/2024 0:009
Amy5/31/2024 0:008
Amy6/3/2024 0:008.5
Amy6/4/2024 0:008
Amy6/5/2024 0:0012.5
Amy6/6/2024 0:006
Amy6/7/2024 0:008
Amy6/10/2024 0:008
Amy6/11/2024 0:008.5
Amy6/12/2024 0:008
Amy6/13/2024 0:008
Amy6/14/2024 0:008
Amy6/17/2024 0:008
Amy6/18/2024 0:007.5
Amy6/19/2024 0:007.5
Amy6/20/2024 0:008
Amy6/21/2024 0:008.5
Amy6/24/2024 0:008
Amy6/25/2024 0:008
Amy6/26/2024 0:008.5
Amy6/27/2024 0:008
Amy6/28/2024 0:008.5
Amy7/1/2024 0:008
Amy7/2/2024 0:008
Amy7/3/2024 0:008
Amy7/4/2024 0:008
Amy7/5/2024 0:008
Amy7/8/2024 0:008
Amy7/9/2024 0:008
Amy7/10/2024 0:008
Amy7/11/2024 0:008
Amy7/12/2024 0:008
Amy7/15/2024 0:008.5
Amy7/16/2024 0:008.5
Amy7/17/2024 0:008
Amy7/18/2024 0:007.5
Amy7/19/2024 0:007.5
Amy7/22/2024 0:008.8
Amy7/23/2024 0:008
Amy7/24/2024 0:008
Amy7/25/2024 0:006.2
Amy7/26/2024 0:008
Amy7/29/2024 0:008
Amy7/30/2024 0:008
Amy7/31/2024 0:008
Amy8/1/2024 0:008
Amy8/2/2024 0:008
Amy8/5/2024 0:008
Amy8/6/2024 0:008
Amy8/7/2024 0:008
Amy8/8/2024 0:008
Amy8/9/2024 0:008
Amy8/12/2024 0:008
Amy8/13/2024 0:009
Amy8/14/2024 0:009.8
Amy8/15/2024 0:0010
Amy8/16/2024 0:008
Amy8/19/2024 0:008
Amy8/20/2024 0:007
Amy8/21/2024 0:009
Amy8/22/2024 0:008
Amy8/23/2024 0:008
Amy8/26/2024 0:008
Amy8/27/2024 0:008
Amy8/28/2024 0:008
Amy8/29/2024 0:008
Amy8/30/2024 0:008
Amy9/2/2024 0:008
Amy9/3/2024 0:008
Amy9/4/2024 0:008
Amy9/5/2024 0:008
Amy9/6/2024 0:009
Amy9/9/2024 0:007
Amy9/10/2024 0:008.5
Amy9/11/2024 0:008
Amy9/12/2024 0:007
Amy9/13/2024 0:009
Amy9/16/2024 0:008
Amy9/17/2024 0:008.5
Amy9/18/2024 0:008
Amy9/19/2024 0:007.5
Amy9/20/2024 0:008
Amy9/23/2024 0:007.5
Amy9/24/2024 0:008.5
Amy9/25/2024 0:008
Amy9/26/2024 0:008
Amy9/27/2024 0:008
Amy9/30/2024 0:008
Amy10/1/2024 0:008
Amy10/2/2024 0:008
Amy10/3/2024 0:008
Amy10/4/2024 0:008
Amy10/7/2024 0:009.5
Amy10/8/2024 0:007.5
Amy10/9/2024 0:008.5
Amy10/10/2024 0:008
Amy10/11/2024 0:007
Amy10/14/2024 0:007.5
Amy10/15/2024 0:008
Amy10/16/2024 0:008.5
Amy10/17/2024 0:008
Amy10/18/2024 0:008
Amy10/21/2024 0:008
Amy10/22/2024 0:008
Amy10/23/2024 0:008
Amy10/24/2024 0:008
Amy10/25/2024 0:008
Amy10/28/2024 0:007.5
Amy10/29/2024 0:008
Amy10/30/2024 0:008.5
Amy10/31/2024 0:008
Amy11/1/2024 0:008
Amy11/4/2024 0:008
Amy11/5/2024 0:008
Amy11/6/2024 0:008
Amy11/7/2024 0:008.5
Amy11/8/2024 0:008
Amy11/11/2024 0:008.2
Amy11/12/2024 0:008
Amy11/13/2024 0:008
Amy11/14/2024 0:008
Amy11/15/2024 0:008
Amy11/18/2024 0:007
Amy11/19/2024 0:0010
Amy11/20/2024 0:008.5
Amy11/21/2024 0:008
Amy11/22/2024 0:008
Amy11/25/2024 0:008
Amy11/26/2024 0:008
Amy11/27/2024 0:008
Amy11/28/2024 0:008
Amy11/29/2024 0:008
Message 9 of 13
371 Views
0
Ritaf1983
Super User
Super User

‎11-25-2024 08:54 PM

Hi @ajitsahoo8338 

You can use measure like :

Fixed_ = SUMX('Table', IF('Table'[Work Hours]<=8,'Table'[Work Hours],8))
Ritaf1983_0-1732596767760.png

The total is correct, i added ra ow to show what happened with more than 8 hours 

The pbix ix attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 
Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
more than 8.pbix
Message 2 of 13
453 Views
0
ajitsahoo8338
Helper III
Helper III
In response to Ritaf1983

‎11-25-2024 10:51 PM

Hello @Ritaf1983 This works but If add a date slicer then it is not working. Can you please try this below using a date slicer

EmployeeDateWork Hours
Amy3/11/2024 0:008
Amy3/12/2024 0:008
Amy3/13/2024 0:008
Amy3/14/2024 0:008
Amy3/15/2024 0:008
Amy3/18/2024 0:008
Amy3/19/2024 0:008
Amy3/20/2024 0:008
Amy3/21/2024 0:008
Amy3/22/2024 0:008
Amy3/25/2024 0:008
Amy3/26/2024 0:009
Amy3/27/2024 0:008
Amy3/28/2024 0:008
Amy3/29/2024 0:008.5
Amy4/1/2024 0:008.5
Amy4/2/2024 0:008
Amy4/3/2024 0:0010.5
Amy4/4/2024 0:008.5
Amy4/5/2024 0:008.5
Amy4/8/2024 0:006.5
Amy4/9/2024 0:008.5
Amy4/10/2024 0:009
Amy4/11/2024 0:0010
Amy4/12/2024 0:008
Amy4/15/2024 0:009
Amy4/16/2024 0:009
Amy4/17/2024 0:009
Amy4/18/2024 0:007
Amy4/19/2024 0:007.5
Amy4/22/2024 0:009.5
Amy4/23/2024 0:009
Amy4/24/2024 0:008
Amy4/25/2024 0:007
Amy4/26/2024 0:008
Amy4/29/2024 0:009
Amy4/30/2024 0:007.5
Amy5/1/2024 0:008
Amy5/2/2024 0:008
Amy5/3/2024 0:008
Amy5/6/2024 0:008
Amy5/7/2024 0:007
Amy5/8/2024 0:008.5
Amy5/9/2024 0:008.5
Amy5/10/2024 0:008
Amy5/13/2024 0:008
Amy5/14/2024 0:009
Amy5/15/2024 0:008.5
Amy5/16/2024 0:008.5
Amy5/17/2024 0:008
Amy5/20/2024 0:009
Amy5/21/2024 0:008
Amy5/22/2024 0:008
Amy5/23/2024 0:008
Amy5/24/2024 0:008
Amy5/27/2024 0:008
Amy5/28/2024 0:008
Amy5/29/2024 0:008
Amy5/30/2024 0:009
Amy5/31/2024 0:008
Amy6/3/2024 0:008.5
Amy6/4/2024 0:008
Amy6/5/2024 0:0012.5
Amy6/6/2024 0:006
Amy6/7/2024 0:008
Amy6/10/2024 0:008
Amy6/11/2024 0:008.5
Amy6/12/2024 0:008
Amy6/13/2024 0:008
Amy6/14/2024 0:008
Amy6/17/2024 0:008
Amy6/18/2024 0:007.5
Amy6/19/2024 0:007.5
Amy6/20/2024 0:008
Amy6/21/2024 0:008.5
Amy6/24/2024 0:008
Amy6/25/2024 0:008
Amy6/26/2024 0:008.5
Amy6/27/2024 0:008
Amy6/28/2024 0:008.5
Amy7/1/2024 0:008
Amy7/2/2024 0:008
Amy7/3/2024 0:008
Amy7/4/2024 0:008
Amy7/5/2024 0:008
Amy7/8/2024 0:008
Amy7/9/2024 0:008
Amy7/10/2024 0:008
Amy7/11/2024 0:008
Amy7/12/2024 0:008
Amy7/15/2024 0:008.5
Amy7/16/2024 0:008.5
Amy7/17/2024 0:008
Amy7/18/2024 0:007.5
Amy7/19/2024 0:007.5
Amy7/22/2024 0:008.8
Amy7/23/2024 0:008
Amy7/24/2024 0:008
Amy7/25/2024 0:006.2
Amy7/26/2024 0:008
Amy7/29/2024 0:008
Amy7/30/2024 0:008
Amy7/31/2024 0:008
Amy8/1/2024 0:008
Amy8/2/2024 0:008
Amy8/5/2024 0:008
Amy8/6/2024 0:008
Amy8/7/2024 0:008
Amy8/8/2024 0:008
Amy8/9/2024 0:008
Amy8/12/2024 0:008
Amy8/13/2024 0:009
Amy8/14/2024 0:009.8
Amy8/15/2024 0:0010
Amy8/16/2024 0:008
Amy8/19/2024 0:008
Amy8/20/2024 0:007
Amy8/21/2024 0:009
Amy8/22/2024 0:008
Amy8/23/2024 0:008
Amy8/26/2024 0:008
Amy8/27/2024 0:008
Amy8/28/2024 0:008
Amy8/29/2024 0:008
Amy8/30/2024 0:008
Amy9/2/2024 0:008
Amy9/3/2024 0:008
Amy9/4/2024 0:008
Amy9/5/2024 0:008
Amy9/6/2024 0:009
Amy9/9/2024 0:007
Amy9/10/2024 0:008.5
Amy9/11/2024 0:008
Amy9/12/2024 0:007
Amy9/13/2024 0:009
Amy9/16/2024 0:008
Amy9/17/2024 0:008.5
Amy9/18/2024 0:008
Amy9/19/2024 0:007.5
Amy9/20/2024 0:008
Amy9/23/2024 0:007.5
Amy9/24/2024 0:008.5
Amy9/25/2024 0:008
Amy9/26/2024 0:008
Amy9/27/2024 0:008
Amy9/30/2024 0:008
Amy10/1/2024 0:008
Amy10/2/2024 0:008
Amy10/3/2024 0:008
Amy10/4/2024 0:008
Amy10/7/2024 0:009.5
Amy10/8/2024 0:007.5
Amy10/9/2024 0:008.5
Amy10/10/2024 0:008
Amy10/11/2024 0:007
Amy10/14/2024 0:007.5
Amy10/15/2024 0:008
Amy10/16/2024 0:008.5
Amy10/17/2024 0:008
Amy10/18/2024 0:008
Amy10/21/2024 0:008
Amy10/22/2024 0:008
Amy10/23/2024 0:008
Amy10/24/2024 0:008
Amy10/25/2024 0:008
Amy10/28/2024 0:007.5
Amy10/29/2024 0:008
Amy10/30/2024 0:008.5
Amy10/31/2024 0:008
Amy11/1/2024 0:008
Amy11/4/2024 0:008
Amy11/5/2024 0:008
Amy11/6/2024 0:008
Amy11/7/2024 0:008.5
Amy11/8/2024 0:008
Amy11/11/2024 0:008.2
Amy11/12/2024 0:008
Amy11/13/2024 0:008
Amy11/14/2024 0:008
Amy11/15/2024 0:008
Amy11/18/2024 0:007
Amy11/19/2024 0:0010
Amy11/20/2024 0:008.5
Amy11/21/2024 0:008
Amy11/22/2024 0:008
Amy11/25/2024 0:008
Amy11/26/2024 0:008
Amy11/27/2024 0:008
Amy11/28/2024 0:008
Amy11/29/2024 0:008
Message 4 of 13
369 Views
0
Ritaf1983
Super User
Super User
In response to ajitsahoo8338

‎11-25-2024 11:26 PM

Hו @ajitsahoo8338 
Tried with the slicer and worked perfectly too 

Ritaf1983_0-1732605916355.png

you can download the updated pbix and follow ...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
more than 8.pbix
Message 5 of 13
363 Views
0
ajitsahoo8338
Helper III
Helper III
In response to Ritaf1983

‎11-25-2024 11:45 PM

Hello @Ritaf1983 It is working for this dataset. but in my original dataset,  I don't know why it is not working. I have 100 employees

ajitsahoo8338_0-1732607053024.png

 

Message 6 of 13
357 Views
0
ajitsahoo8338
Helper III
Helper III
In response to Ritaf1983

‎11-25-2024 09:10 PM

Hello @Ritaf1983 Thank you for your response. This is not working when the date filter is applied. Please check below.

ajitsahoo8338_0-1732597823144.png

 

Message 3 of 13
428 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

View All