topic Re: FILTER ALL? in DAX Commands and Tips

FILTER ALL?

Joshua_ — Tue, 10 Dec 2019 19:09:43 GMT

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.

Re: FILTER ALL?

az38 — Tue, 10 Dec 2019 20:13:30 GMT

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

Re: FILTER ALL?

Joshua_ — Wed, 11 Dec 2019 11:57:26 GMT

Thank you!