Forum Discussion
tabular model - filtering records based on date slicer
This did end up meeting the requirements specifically as I stated them, which is to say that it allows me to filter a table.
Unfortunatley, the table was just a specific instance of a more general requirement, and that is to be able to filter more or less any visualization based on the date I select.
For example, say I want a card that will count the award records that are displayed in my filtered table. Or, I want the sum of award amounts from the records displayed in the filtered table.
My expectation was that once I had a filter flag (your IfIn measure), I could then use that as a page level filter. Alas, I cannot (perhaps because a measure can't be used as a page level filter).
I'm really looking for a general solution to how to select an "as of" date for a report that is driven by a tabular model with historical data. I am open to other ways of designing the tabular model itself.