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

Stop YTD measure from being filtered by date Slicer

Hi all,

I'm editing a Power BI report so that members of our HR team gain more value from it, and I'm currently having an issue with a Year-To-Date measure being filtered by the date Slicer function. Is it possible to stop this from happening? I would like to keep the YTD measure as part of the visualisation that is being filtered by the Slicer, if this is possible.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello all,

 

I've finally figured it out! Here's the code I used to ensure that my YTD column (I changed it from a measure to a column) won't be affected by the date slicer.

Sick Leave YTD Column =
CALCULATE(
ABS(SUM('cdm_leavebanktransactions (2)'[cdm_amount])),
DATESYTD('cdm_leavebanktransactions (2)'[cdm_transactiondate].[Date]),
'cdm_leavetypes (2)'[cdm_type] = "Sick Leave",
'cdm_leaverequests (2)'[cdm_status] = 754400002
)
I added a couple of filters to ensure it returns the correct amount.

View solution in original post

14 REPLIES 14

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.