Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
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:
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |