Forum Discussion
Slicer not working with Measure
I am currenty working on a dashboard where I want to use a slicer to show differing rowcounts of various tables depending on the date selected. I havean accounting table with a row_count measure which shows the total row count regardless of the date period selected by the slicer. The measure has the following formula:
I have a date table which which has a 1 to many relationship to the accounting table. Other measure which i have on the canvas are respondoing to the slicer as shown below.
I am not sure where I could be going wrong. any ideas. Thanks in Advance
Hi Anonymous ,
I've noticed that your measure uses the ALL function, which ignores all filters, including slicers.
If you want to ignore filters that are unexpected in addition to the slicer, use ALLSELECTED function .
The ALLSELECTED function gets the context that represents all rows and columns in the query, while keeping explicit filters and contexts other than row and column filters.
ALL function (DAX) - DAX | Microsoft Learn
ALLSELECTED function (DAX) - DAX | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Anonymous ,
I've noticed that your measure uses the ALL function, which ignores all filters, including slicers.
If you want to ignore filters that are unexpected in addition to the slicer, use ALLSELECTED function .
The ALLSELECTED function gets the context that represents all rows and columns in the query, while keeping explicit filters and contexts other than row and column filters.
ALL function (DAX) - DAX | Microsoft Learn
ALLSELECTED function (DAX) - DAX | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
Not sure which measure you are referring here, which is not impacted by the date slicer. Is it the "Accounting Row Count" measure?
Thanks
hi Sourav_M , my apoligies. it is indeed the Accounting Row Count
