CubeValue - Multiple Fields

Good Afternoon, Can anybody please tell me if it is possible to have multiple fields such as...

=CubeValue("Connection", "[Measures].[DLV Sales $ TYR]", "[Staff].[6218]", "[Staff].[6318]")

Or does the two need to be added together such as

=CubeValue("Connection", "[Measures].[DLV Sales $ TYR]", "[Staff].[6218]") + CubeValue("Connection", "[Measures].[DLV Sales $ TYR]", "[Staff].[6318]")

The first option does not seem to work for me, but maybe I am doing something wrong, its seems like a lot of work if I want to choose a selection of about twenty salespeople
(not that I want to, but would like to understand this better)

Thank you
Grant McConville

Try adding a cubeset formula to your cubevalue.

=CUBEVALUE("Connection","[Measures].[DLV Sales & TYR]", CUBESET("Connection","{[Staff].&[6218],[Staff].&[6318]}"))

You can also insert a slicer for staff and reference the slicer in your cubevalue formula:


=CUBEVALUE("Connection","[Measures].[DLV Sales & TYR]", slicer_staff)