Error using "ALL" with two filters

[Syndicate_Admin]

Good morning Dear ones, please your help:

create the following action

Q_consultas = CALCULATE(COUNT(example[episodio1]),ALL(example[linea_negocio_derivacion]))

The idea is to count the number of episodes without filtering through the "linea_negocio_derivacion" column, the filter works perfectly individually and in combination with other filters, but when combining this filter with the date filter, the measure ignores the all and activates the "linea_negocio_derivacion" filter, so the objective is not met.

Data:

Examples of correct operation of the filter

Examples of filter malfunction, the second image should not change the measurement when filtering:

Some idea of why it may occur.

[v-xiaotang · Accepted solution]

Hi @Syndicate_Admin 

Thanks for reaching out to us.

>> but when combining this filter with the date filter, the measure ignores the all and activates the "linea_negocio_derivacion" filter, so the objective is not met.

You can try this,

Best Regards,

Community Support Team _Tang

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

[amitchandak]

@Syndicate_Admin , Based on what I got. Try like

Q_consultas = CALCULATE(COUNT(example[episodio1]),ALL(example))

or

Q_consultas = CALCULATE(COUNT(example[episodio1]),ALL())