Filtered measures across date ranges using a many-to-many relationship with dates | Help and How-To

npatel_02 · 2025-05-14T10:15:03.893000Z

Hi there, Following on from the post regarding filtering inventory on a dashboard, I was able to create a pre-calculated date value for each row in the main inventory model, allowing for single-select filtering. Using the same date dimension and inventory model, I was hoping to employ filtered measures to create two columns each comparing the summation of values across two specific dates (like an opening and closing count of units). This is my current work around for getting the calculations across a date range, however I know that akaplan already considered that this would be difficult given the many-to-many relationship that exists between the models.Is this what is causing my issue here? As shared in the attached, it does not seem to apply measured filters at all now. Appreciate any advice/considerations on these filtered measures, Thanks in advance

MoreDiscussions

Filtered measures across date ranges using a many-to-many relationship with dates | Help and How-To | Sisense Community