Valid if Drop-down list only for some countries User Settings

Hello everyone! I am doing a valid If to show a drop-down list related to today's date SELECT(SCHEDULE[LIST], [DATE] = TODAY()) but I would like there to be an exception for a specific Country that was previously selected in User Settings And for that country the entire list of the [SCHEDULE] table is shown, as I would do the expression I have tried to do but without success ... Thanks for your Help

Solved Solved
0 3 97
1 ACCEPTED SOLUTION

IF(
  [_THISUSER].[COUNTRY]<>"THE_COUNTRY",
  SELECT(SCHEDULE[LIST], [DATE] = TODAY()),
  SCHEDULE[LIST]
)

View solution in original post

3 REPLIES 3

IF(
  [_THISUSER].[COUNTRY]<>"THE_COUNTRY",
  SELECT(SCHEDULE[LIST], [DATE] = TODAY()),
  SCHEDULE[LIST]
)

Thank you very much for your time and help!

Steve
Platinum 4
Platinum 4
Top Labels in this Space