Solved: Filtering Suggested Values - Page 2

Nick_S · 09-22-2021 05:16 AM

Attempting to show values in suggested values, but only if they meet a certain criteria

Expression being used:
LIST((Player Stats[Raiders:]), FILTER(Player Stats,[PvE Tier:]=“1”))
Instead of:
Player Stats[Raiders:]
-For this particular column, I am seeking to only display values from Player Stats[Raiders:], if the value in the “PvE Tier:” column is equal to 1.

Receiving this error:
Column Name ‘1st Summoner:’ in Schema ‘SB Roles_Schema’ of Column Type ‘Enum’ has invalid ‘Suggested Values’ of ‘=LIST((Player Stats[Raiders:]), FILTER(Player Stats,[PvE Tier:]=“1”))’. The type of the Suggested Values does not match the column type.

-I assume I am using the FILTER() function improperly.

Aurelien

Hi @Nick_S

What about:
(assuming [PvE Tier:] is text type)

FILTER("Player Stats",
  [PvE Tier:]=“1”
)

or
(assuming [PvE Tier:] is number type)

FILTER("Player Stats",
  [PvE Tier:]=1
)

also, please set this expression in the Valid_If field instead of Suggested Values

View solution in original post