The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All
I am trying to get a full year budget using a measure. I have tried REMOVEFILTERS and ALL functions and they don't seem to work. What I am tring to ignore is the date slicer:
Solved! Go to Solution.
Hi @Sehlola
Please try below DAX
Annual Budget = CALCULATE(SUM('2023'[Value]),REMOVEFITLER(Table[Month]),FILTER('2023','2023'[Type] = "Budget"))
Make sure you are using same filed in REMOVEFILTER which is using in Slicer
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Proud to be a Super User! | |
Hi @Sehlola
Please share your Data Model
Which field you are using in Slicer
If possible create and share link for sample PBIX file
Proud to be a Super User! | |
Hi @Sehlola
Please try below DAX
Annual Budget = CALCULATE(SUM('2023'[Value]),REMOVEFITLER(Table[Month]),FILTER('2023','2023'[Type] = "Budget"))
Make sure you are using same filed in REMOVEFILTER which is using in Slicer
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Proud to be a Super User! | |
Unfortunately it still gives me the same result.
User | Count |
---|---|
79 | |
73 | |
39 | |
30 | |
28 |
User | Count |
---|---|
108 | |
99 | |
55 | |
49 | |
45 |