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 joiners I get the following numbers, March 39, April 61, Total 100. what I want to get is 39 in march and 22 in April. = April number minus March Number, going forward it would be May number minus March number etc. is there a way to do this ?

my table looks like so: team name // FTE Alpha 5 Bravo 3 Charlie 4 Delta 5 Echo 1 Foxtrot 6 Golf 9 Hotel 17 India 4 how can I write a measure so that it sums up all the FTE's except for FTE's in teams India & Foxtrot ?

putting a bunch of filters in calculate function doesn't feel the most efficient way
  • neylamela 

    Try this measure:

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

2 Replies

  • RayWu's avatar
    RayWu
    Icon for Memorable Member rankMemorable Member

    neylamela 

    Try this measure:

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