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)
Solved! Go to 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.
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.
Unfortunately I need to have this expression and not concatenate it
You are getting two values. What do you need to do with them?
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.
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])))
Use switch or if or ifs
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |