Select from a dropdown and return a predefined or a user defined values

[Curio_PG]

Hi there!

Hope someone can help me as I have been struggling with this for days.

I am trying to create an app that will calculate the volume of a package.

There are 5 different packages i.e. A, B, C, D and E.
The user will see a dropdown (ENUM) and select the Package.
The user can only choose one type of Package.
When the package is selected, the corresponding Volume is captured.

For A, B and C, the Volume is known and is fixed. See the above table.

However, if the user selects either D or E, an input field should appear, where the user can enter any value. This user defined value is then captured instead.

Thank you.

[LeventK]

Initial Value expression for Volume:

IFS(
    IN(
		{"A" , "B" , "C"},
		Tablename[Package]
	),
	LOOKUP(
		[_THISROW].[Package],
		"TableName",
		"Package",
		"Volume"
	)
)

[Curio_PG]

Thank you so much Levent. I will try it out.

[LeventK]

You’re welcome

[Human_Resources]

I am trying to construct a Valid If() Statement to filter out previously selected values by the user.

SELECT(Board [Board], true) -SELECT(Board Registration[Board],CONTAINS(Gifter[Gifter], [_THISROW].[Gifter]), true)

This works but it filters out the values selected by any user.

Please can you assist me with the formula.

[Human_Resources]

SELECT(Board [Board], true) - SELECT(Board Registration[Board],( [Gifter] = [_ThisRow].[Gifter]), true)

Figured it out!!