FILTER ALL?

[Joshua_]

Hi,

I have the following measure.

The measure is correct, because I get all the sales (Coloc Productiva), but in my dashboard have filters externs, for example the months,type... and that when changing the filter, the measure does not change.

Would I have to add more filters in my measure? One for date, another for the type? 

Thank you very much.

Regards.

[az38 · Accepted solution]

Hi @Joshua_ 

its a correct behaviour because you are using ALL() function that clear all functions.

try 

=calculate(sum([_Saldo_Real_Mes_T_]), SIMR[GRUPO]="Coloc Productiva")

or change ALL() to ALLSELECTED or ALLEXCEPT. it depends on user behaviour in your report

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[Joshua_]

Thank you!