Problem with SWITCH and HASONEFILTER conditionals applying it to the MassFilter display object

Hi Syndicate_Admin ,

According to your description, in my understanding, if the Cant DNISelec get a value, take it ,else if it is empty then catch those that are in each What if of each city. If this is the case, you can try this measure.

Measure =
IF (
    COUNTROWS ( 'tablaHabitantes'[DNI] ) + 0 <> 0,
    COUNTROWS ( 'tablaHabitantes'[DNI] ),
    SWITCH (
        TRUE (),
        MAX ( 'Cities-Values Pant'[Cities] ) = "MADRID", SelectMadrid[Madrid Value],
        MAX ( 'Cities-Values Pant'[Cities] ) = "MADRID AM", 'SelectMadrid AM'[Madrid AM Value],
        MAX ( 'Cities-Values Pant'[Cities] ) = "BARCELONA", SelectBarcelona[Value Barcelona],
        MAX ( 'Cities-Values Pant'[Cities] ) = "BARCELONA AM", 'SelectBarcelona AM'[Value Barcelona AM],
        MAX ( 'Cities-Values Pant'[Cities] ) = "VALENCIA", 'SelectValencia'[Valencia Value],
        MAX ( 'Cities-Values Pant'[Cities] ) = "SEVILLE", 'SelectSevilla'[Value SEVILLA],
        MAX ( 'Cities-Values Pant'[Cities] ) = "MALAGA", 'SelectMálaga'[Malaga Value],
        MAX ( 'Cities-Values Pant'[Cities] ) = "MARBELLA", 'SelectMarbella'[SelectMarbella Value],
        MAX ( 'Cities-Values Pant'[Cities] ) = "CORDOBA", 'SelectCórdoba'[SelectCordoba Value],
        MAX ( 'Cities-Values Pant'[Cities] ) = "GRANADA", 'SelectGranada'[Select ValueGranada],
        MAX ( 'Cities-Values Pant'[Cities] ) = "BILBAO", 'SelectBilbao'[SelectBilbao Value],
        MAX ( 'Cities-Values Pant'[Cities] ) = "VITORIA", 'SelectVitoria'[SelectVitoria Value],
        BLANK ()
    )
)

Best Regards,
Community Support Team _ kalyj

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