Forum Discussion
AS AT slicers
Hi Steve_M
As mentioned in my previous reply, filters coming from a related table will affect what records are visible. So if you select 28/11, you will see only the 28/11 rows. Functions such as ALL, ALLSELECTED, REMOVEFILTERS etc affect the results of a measure but cannot unhide the non-selected rows. Change your slicer to before if you want to also show rows with dates prior to the currently selected.
Thanks Samarth, I still get the same result. Below is what I am trying to achieve; when the date selected is, say, the 28th Nov, I want to calculate using that date. If the date selected is 31st Dec, which is greater than today, then use today's date. You can see in the debug slicer that the code to calculate the second date is working, but when it is used in the visual with filtering turned off, the MAX returns the max of the date table and not the date selected. I don't even know if this is possible. Working with a Live connection is making it hard but it what I have to deal with
Super UserHi Steve_M
As mentioned in my previous reply, filters coming from a related table will affect what records are visible. So if you select 28/11, you will see only the 28/11 rows. Functions such as ALL, ALLSELECTED, REMOVEFILTERS etc affect the results of a measure but cannot unhide the non-selected rows. Change your slicer to before if you want to also show rows with dates prior to the currently selected.
Thank you, I think this will work with Samarth's code.