Forum Discussion
Remove date filter from DAX measure
Hi CJensen ,
Based on your description, your DAX measure is functioning correctly for calculations it ignores the date slicer due to REMOVEFILTERS(Date). However, this only impacts the calculation, not the rows displayed in your visual.
If your visual, such as a table or matrix, is filtered by the slicer or uses the Date field directly, it will still only display the selected month, even though the measure calculates across all dates.
If you want to display all dates regardless of the slicer, you have a few options
- Remove the slicer’s interaction with the visual.
- Use a disconnected date table for filtering.
- Create a separate visual to show totals for all dates.
I hope that’s helpful. Let me know if you need any further assistance.
Regards,
Yugandhar.
Hi CJensen ,
Based on your description, your DAX measure is functioning correctly for calculations it ignores the date slicer due to REMOVEFILTERS(Date). However, this only impacts the calculation, not the rows displayed in your visual.
If your visual, such as a table or matrix, is filtered by the slicer or uses the Date field directly, it will still only display the selected month, even though the measure calculates across all dates.
If you want to display all dates regardless of the slicer, you have a few options
- Remove the slicer’s interaction with the visual.
- Use a disconnected date table for filtering.
- Create a separate visual to show totals for all dates.
I hope that’s helpful. Let me know if you need any further assistance.
Regards,
Yugandhar.
Hi V-yubandi-msft ,
thank you so much for the help, it got me in the right direction! I created a copy of the table without the date column and now it works.