Ayuda con los filtros

[tatac1412]

Hola, me gustaría saber si hay alguna forma de bloquear las opciones de un filtro con otro filtro, ejemplo tengo un filtro 1 donde estan las opciones DM,   HTA      y HTA o DM . me gustaría si filtro DM en el otro filtro 2 solo se me vea "incidentes DM" y no las otras opciones del filtro2.   Agradezco la ayuda

Filtro 1                                                       

Filtro 2 (Que solo se vea la opción de "Incidentes DM" y las otras no se vean

[Anonymous · Accepted solution]

Hi @tatac1412 ,

I have created a simple sample, please refer to it to see if it helps you.

Create a measure.

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Column1] ) = "DM"
        && MAX ( 'Table (2)'[Column1] ) = "incidentes DM",
    1,
    IF (
        SELECTEDVALUE ( 'Table'[Column1] ) = "HTA"
            && MAX ( 'Table (2)'[Column1] ) = "incidentes HTA",
        1,
        IF (
            SELECTEDVALUE ( 'Table'[Column1] ) = "HTA O DM"
                && MAX ( 'Table (2)'[Column1] ) = "incidentes HTA o DM",
            1,
            BLANK ()
        )
    )
)

Then filter the measure in the slicer 2 is 1.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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

[tatac1412]

Mil gracias!!! funciono perfectamente, me has salvado de una!!!!!

[lbendlin]

- use fields from the same table

- use your data model to create dependencies between fields. 

- use measures to implement your logic and then apply these measures as filters on the visual.