Dynamically select first part of a coloumn merge and put that into small multiples.

[varnanavijay]

Hello Community,

I have a Figure- Curve parameter slicer whose inputs come from figure- curve parameter named parameter field i created from columns of gesamt table. These column are a combination of 2 parameters say for ex Tool- Velocity or Supplier- Temperature . This parameter field is my legend. Now i want to create a column or measure that give the output as the first part of figure-Curve parameter ie in case of tool- velocity it should give tool. so i can put that tool in small multiples and see different tool.

I tried using dax but its not working.

Field =

VAR SelectedParameter = SELECTEDVALUE('Figure - Curve parameters'[Figure - Curve parameters Fields])

VAR FirstField =

    SWITCH(

        SelectedParameter,

        "Velocity-Tool", LEFT(SelectedParameter, FIND("-", SelectedParameter) - 1)

    )

RETURN

    FirstField

not sure if this is correct also.

Regards,

Varnana

[v-zhangti]

Hi, @varnanavijay 

You can try the following methods.

FirstField =
VAR SelectedParameter =
    SELECTEDVALUE ( 'Figure - Curve parameters'[Figure - Curve parameters Fields] )
VAR FirstField =
    LEFT ( SelectedParameter, FIND ( "-", SelectedParameter ) - 1 )
RETURN
    FirstField

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.