lookup()

[Fabio_T]

Is it possible to join/execute both expressions in app formula?

LOOKUP([_THISROW].[ID_Ordineplus], Ordini, ID_Ordineplus, Ref_Operatore_Telefonia_id) 

LOOKUP([_THISROW].[ID_Ordineplus], Ordini, ID_Ordineplus, Ref_Operatore _Energia_id)

[TeeSee1 · Accepted solution]

You can. Since you would be retrieving two values, you have to either concatenate them to merge them into a single value or make a list with them.

[Fabio_T]

Unfortunately I need to have this expression and not concatenate it

[TeeSee1]

You are getting two values. What do you need to do with them?

[Fabio_T]

I need the two values ​​to use them in a deck view based on another value associated with them

EXAMPLE the main values ​​in deck view are
energy and telephony
and according to them in the Summary column have either the first or the other.

[Fabio_T]

Alternatively, these two expressions can be used simultaneously

Alternatively, these two expressions can be used simultaneously?

ANY(SELECT(Ordini[Ref_Operatore_Telefonia_id],([ID_Ordineplus] = [_THISROW].[ID_Ordineplus])))

ANY(SELECT(Ordini[Ref_Operatore _Energia_id],([ID_Ordineplus] = [_THISROW].[ID_Ordineplus])))

[TeeSee1]

Use switch or if or ifs