Skip to main content
cancel
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

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.
12 REPLIES 12
mussaenda
Super User
Super User

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?

Kedar_Pande
Super User
Super User

@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

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
Suresh604
Frequent Visitor

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

Hello @Suresh604 

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

ajitsahoo8338_0-1732599082120.png

 

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

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
Ritaf1983
Super User
Super User

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

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

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

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

 

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

ajitsahoo8338_0-1732597823144.png

 

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.