Two columns as segmentation

[ponchibonos]

I have a table with two columns of responsibles of a Proyect. 

Is possible to slice my data with the two columns independently?

For example: When I selected "Ale" the slicer shows the data in wich Ale appears in both columns RESPONSABLE and RESPONSABLE 2?

At now, when I selected "Ale" just shows the data of the column RESPONSABLE

Thanks in advanced

[Anonymous · Accepted solution]

Hi @ponchibonos ,

In addintion to  lbendlin's reply, you need to create an unrelated DIMRESPONABLE table and then create a measure to filter your visual.

DIMRESPONSABLE = 
DISTINCT (
    UNION ( VALUES ( 'Table'[RESONSABLE] ), VALUES ( 'Table'[RESONSABLE 2] ) )
)

Measure:

Filter = 
VAR _SELECTED =
    VALUES ( DIMRESPONSABLE[RESONSABLE] )
RETURN
    IF (
        MAX ( 'Table'[RESONSABLE] )
            IN _SELECTED
                || MAX ( 'Table'[RESONSABLE 2] ) IN _SELECTED,
        1,
        0
    )

Add this measure into visual level filter and set it to show items when value = 1. Result is as below.

Best Regards,
Rico Zhou

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

[ponchibonos]

Thanks @Anonymous this was the solution. 

[lbendlin]

You need to use disconnected slicers if you want independent filters.