Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @Sehlola
Please share your Data Model
Which field you are using in Slicer
If possible create and share link for sample PBIX file
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
Unfortunately it still gives me the same result.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |