We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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 |
---|---|
67 | |
61 | |
47 | |
35 | |
32 |
User | Count |
---|---|
87 | |
72 | |
56 | |
49 | |
45 |