How to ignore filters in date dimenson

[hanschucrutes]

Hello everyone, I'm trying to create a table where I'll display the data that is active in the system, showing every piece of data that has yet to expire, ignoring the year filter. In a measure, I know I can use a set analysis 'sum({<[Year]=>}, product)' to ignore a filter, but for a date that needs to be displayed, I'm not sure how it should be handled. Can anyone help?

[MatheusC · Accepted solution]

Hi, @hanschucrutes 

You want to ignore the Year= filter, within your date dimension?

See it like this, Modify with your original fields:

=aggr(Only({<Year=>}Date),Date)

Regarts, Matheus

[hanschucrutes]

Thank you very much