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

Sorry I did a mistake on what I mean =>

----------------------------

Quantity                  Ship Mode                   Destination      Year

8                               First Class                    France              2019

3                               First Class                    Usa                   2019

10                             First Class                    France              2020

 

The Average we saw before will give  (10+3+8)/3 =7

The Average for distinct Destination will give ( 18 + 3 ) /2 = 10,5

How can I do that?

----------

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

PatrickByGecko,

 

Here you go,

DIVIDE(SUM(Orders[Quantity]), DISTINCTCOUNT(Orders[Destination ]))

 

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