Set Analysis - How to select a max dimension regardless of other filters

[annick]

Hello,

I have a table with the following dimensions:

- Year (e.g. 2022)
- Month (e.g. Jan)
- Date  (e.g. 01Jan2022)
- ProductType
- ProductCode
- Color
- etc...

When selecting the following dimensions:

- A Year (and optionally a Month and optionally a Date )
- A ProductType or a ProductCode or a Color or any other dimensions

I would like to compute the MAX Date corresponding to the Year/Month/Date selection, regardless of the other selection (productType, ProductCode, Color etc...)

Many thanks

Kind regards

Annick

[ogster1974]

If you add the following into your set analysis then you will ignore the filters in those fields.

Max({<productType=, ProductCode=, Color=>} Date)

[annick]

Hello,

Thanks a lot for your quick reply. Unfortunately I have around 50 other dimensions on top of productType, ProductCode and Color that I would need to ignore. Do I have to specify them all in the set analysis?

Many thanks

Kind Regards

[ogster1974]

Set up an Alternate State in master Items e.g. Date Only

Create your measure Max({Date Only} Date)

Create filters for your year, quarter, month and then apply the state to the filter.  

Should control your date independent of other filters applied.

[ogster1974]

As you can see in this example the max order date is driven off the filter on year for the altered state whilst other objects still display all the order dates.

[annick]

Thanks a lot for your detailed reply. Unfortunately I do not have access to the Alternate State capability .

Would there be another way to achieve this? Otherwise, I will use your first solution i.e. Max({<productType=, ProductCode=, Color=, Dimension1=, Dimension2=, etc... >} Date)

Thanks a lot

Annick

[ogster1974 · Accepted solution]

That's a shame.  I think you'll have to go with the first option.