Always one selected value

[MindaugasBacius]

Hello,

I do face some issue with option Always one selected value.

I have few sheets in an app. All the sheets have the same dimension called Date.

In one of the sheets I need to apply Always one selected value for Date dimension. Unfortunately, when I choose this option it applies to all the sheets.

What would be the workaround for this kind of problem?

Thank you in advance!

[tresesco]

May be create an alternate state and assign it to the date field where specifically the 'Always One Selected Value' would be required. However, as an extra you have to include this date field (in alternate state) all the expression explicitly in that sheet. 

[niclaz79 · Accepted solution]

This one is a bit tricky, but I would create an island table with all the possible dates, column called DateSelection or similar.

DateSelectionTable:

LOAD distinct

    Date as DateSelection

Resident ...;

Then I would use that dimension in the sheet you need to be always one selected as the date selection. In the expression than you can reference the selected date in the set-expression using Date = P(DateSelection). This way you are not interfering with the Date-dimension in any way outside that expression.