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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Have a Measure Ignore Certain Slicers

I'm trying to get my report's YTD budget and actual calculation to ignore the filters at the bottom but can't get it to work.  For example, if I start with:

HC97_0-1604979604100.png

 

And then change either boundary of the date range, the YTD Budget and actuals just becomes equal to the MTD budget and actual. It should show a total value from 1/7/20 to the selected date regardless of the lower limit selected. the DAX formulas currently looks like:

RBudgetYTD = CALCULATE(SUM(Complete[Bales]), Complete[Type] = "Budget", Complete[Split] <> "Sold", FILTER(ALLSELECTED(Complete[ODate]), AND(Complete[ODate] <= MAX(Complete[ODate]), Complete[ODate] >= DATE(2020,07,01))), ALLEXCEPT(Complete, Complete[Company], Complete[Division], 'Complete'[Region], Complete[Rep]), Complete[ODate] <= TODAY())
 
Can anyone potentially help me with this?
 
Thank you.
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You'll want to use ALL() or ALLEXCEPT() against the field that feeds the slicer ("Month Selector" in your case),  or you can also use the "disconnected slicer table"  approach for more flexibility.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

You'll want to use ALL() or ALLEXCEPT() against the field that feeds the slicer ("Month Selector" in your case),  or you can also use the "disconnected slicer table"  approach for more flexibility.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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