Forum Discussion

Joshua_'s avatar
Joshua_
Icon for Helper II rankHelper II
6 years ago
Solved

FILTER ALL?

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... an...
  • az38's avatar
    az38
    6 years ago

    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

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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_'s avatar
    Joshua_
    Icon for Helper II rankHelper II
    6 years ago

    Thank you!