Forum Discussion

Jensej's avatar
Jensej
Helper V
6 years ago
Solved

Checking Employee Count on specific date.

Hello There!    So im pretty new to Power BI.    Our company has some Groups with assisted living. (5 floors/groups)    I have made a report where i can see Total amount of residents,gender, av...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Jensej ,

    Just update your old measure, not write a new measure, add the group field in the below filter, refer to the previous formula in variable:

    filter(allexcept(bi_employee,bi_employee(gender),bi_employee(group)),...)

     

    Best Regards,
    Yingjie Li

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

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Jensej ,

Just update your old measure, not write a new measure, add the group field in the below filter, refer to the previous formula in variable:

filter(allexcept(bi_employee,bi_employee(gender),bi_employee(group)),...)

 

Best Regards,
Yingjie Li

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

Jensej's avatar
Jensej
Helper V
6 years ago

Hi v-yingjl 

 

Perfekt now it works. I added this part on all 3 measures

FILTER ( ALLEXCEPT(bi_bewohner, bi_bewohner[Geschlecht],bi_bewohner[Gruppe],bi_bewohner[Alter in Jahren],bi_bewohner[Punkte BESA]),

Don't know if it necessary on all 3 measures but it works 🙂 Thanks