Forum Discussion

neylamela's avatar
neylamela
New Member
4 years ago
Solved

headcount visual for new joiners

Hi Guys, I'm creating a headcount visual for new joiners. the source data that I get comes in a form of Year to date rather then Period to Date. so when I write my measure to count all the new joiner...
Need Help
  • RayWu's avatar
    RayWu
    4 years ago

    neylamela 

    Try this measure:

    CALCULATE( SUM ( FTE ) FILTER(TABLE, TEAMNAME IN ("India", "Foxtrot"))

RayWu's avatar
RayWu
Memorable Member
4 years ago

neylamela 

Try this measure:

CALCULATE( SUM ( FTE ) FILTER(TABLE, TEAMNAME IN ("India", "Foxtrot"))

neylamela's avatar
neylamela
New Member
4 years ago
Awesome, thank you!