Forum Discussion
Solved
AS AT slicers
Hi, I am trying to create an “AS AT” AR Aging report. I have a Live connection but I don’t have access to make changes to the underlying data model, so I am trying to do everything in DAX. If I ...
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.
Kedar_Pande
Super User
Super UserUpdated Measure for # Days Open AR:
# Days Open AR =
VAR First_Date =
IF(
ISBLANK(MAX('Transaction Lines'[Due Date/Receive By])),
MAX('Transaction Lines'[Date]),
MAX('Transaction Lines'[Due Date/Receive By])
)
VAR Selected_AsAtDate =
SELECTEDVALUE('Transaction Date'[*Date (trans)], TODAY())
RETURN
DATEDIFF(
First_Date,
MIN(Selected_AsAtDate, TODAY()),
DAY
)
💌If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn