Remove filters from all tables but one specific table

[Infecting91]

Hello,

I've been trying to calculate a total of a table ignoring all filters but the ones associates with the table "Ciclos".

I achieved my objective using the following:

CALCULATE(Pagos[Ventas],REMOVEFILTERS(Programa),REMOVEFILTERS(Source),REMOVEFILTERS(AdGroup),REMOVEFILTERS(AnuncioKW),REMOVEFILTERS(Medium),REMOVEFILTERS(Paises),REMOVEFILTERS('Lead'),REMOVEFILTERS(Persona),REMOVEFILTERS('Estado Lead'),REMOVEFILTERS('Status Lead'),REMOVEFILTERS('Asesor Retención'),REMOVEFILTERS('Asesor Ventas'),REMOVEFILTERS('Tipo Estudiante Income'),REMOVEFILTERS('Tipo Estudiante Outcome'),REMOVEFILTERS('Tipo Pago'),REMOVEFILTERS('Generación'), REMOVEFILTERS(Materia),REMOVEFILTERS('Forma Pago'),REMOVEFILTERS(Canal),REMOVEFILTERS('Campaña'))

However I think its inefficient. Anyone knows another elegant solution?

Thanks

[Anonymous · Accepted solution]

@Infecting91 

Basically you can use KEEPFILTERS and REMOVEFILTERS to control tables filters. 

Measure = CALCULATE(MAX([Column1]),KEEPFILTERS('Table'),REMOVEFILTERS())

KEEPFILTERS function (DAX) - DAX | Microsoft Docs

REMOVEFILTERS function (DAX) - DAX | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Infecting91 

You can use REMOVEFILTERS() without parameters to remove all filters then add the table as an argument tot CALCUALTE to push the filter. 

Measure =
CALCULATE (
    Pagos[Ventas],
    Ciclos,
    REMOVEFILTERS ()
)