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

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.