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... 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'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

2 Replies

  • 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