Forum Discussion

PatrickByGecko's avatar
PatrickByGecko
Icon for Helper V rankHelper V
6 years ago
Solved

This filter clause do as its own mind

Hello I can't understand why this filter returns information about agency of "Paris" and "Aix" when I'm only asking for "Niort". CALCULATE(AVERAGE('Affectation Collaborateurs'[TAUX HSITE]);FILTER(...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi,

    So it seems that you solved this problem, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

    Best Regards,
    Zoe Zhi

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

PatrickByGecko's avatar
PatrickByGecko
Icon for Helper V rankHelper V
6 years ago

Thanks

But it don't works with a filter =>

Moy Hors Site =
CALCULATE(
    DIVIDE (SUM(CollabAffectImmediat[TAUX HSITE])/DISTINCTCOUNT(CollabAffectImmediat[NOM]);
    FILTER(CollabAffectImmediat;CollabAffectImmediat[DATE DEBUT]<=today() && CollabAffectImmediat[DATE FIN]> TODAY() && CollabAffectImmediat[CODE PROJET]<> "GKOFORMA1" && CollabAffectImmediat[CODE PROJET]<>"GKOMAINT1"&& CollabAffectImmediat[CODE PROJET]<>"GKOAVENTE" )
))
I get this error => L'expression fait référence à plusieurs colonnes. Plusieurs colonnes ne peuvent pas être converties en une valeur scalaire.

 

 
SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
6 years ago

PatrickByGecko,

 

Have you tried this?

Calculate(<exp>,

FILTER(CollabAffectImmediat;CollabAffectImmediat[DATE DEBUT]<=today() && CollabAffectImmediat[DATE FIN]> TODAY()) FILTER(CollabAffectImmediat;CollabAffectImmediat[CODE PROJET]<> "GKOFORMA1" && CollabAffectImmediat[CODE PROJET]<>"GKOMAINT1"&& CollabAffectImmediat[CODE PROJET]<>"GKOAVENTE" ))
  • PatrickByGecko's avatar
    PatrickByGecko
    Icon for Helper V rankHelper V
    6 years ago

    Hello

    I succeeded this way =>

     

    Moy Hors Site =
    DIVIDE (
    Calculate (
    SUM(CollabAffectImmediat[TAUX HSITE]);
        FILTER(CollabAffectImmediat;CollabAffectImmediat[DATE DEBUT]<=today() && CollabAffectImmediat[DATE FIN]> TODAY() )
    );
    CALCULATE(
    DISTINCTCOUNT(CollabAffectImmediat[NOM]);
    FILTER(CollabAffectImmediat;CollabAffectImmediat[DATE DEBUT]<=today() && CollabAffectImmediat[DATE FIN]> TODAY() )
    )
    )
     
     
  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi,

    So it seems that you solved this problem, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

    Best Regards,
    Zoe Zhi

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