sum of count of rows

[Anonymous]

in the below image it shows count of EE_ID  accordingly term period. But I need count of sum of EE_ID according to month like 88+66+52+... can you please help me out 

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may add an order column first.Then create a measure like below:

Order = SWITCH(RIGHT(Data[Term Period],3),"Oct",1,"Nov",2,"Dec",3,"Jan",4,"Feb",5,"Mar",6,"Apr",7,"May",8)

Measure =
CALCULATE (
    COUNT ( Data[EE_ID] ),
    FILTER ( ALL ( Data ), Data[Order] <= MAX ( Data[Order] ) )
)

Regards,

[parry2k]

@Anonymous sorry your request is not clear? Can you share what you want output to be?

[Anonymous]

@parry2k 

I need sum of ee_id according to each month listed in the image

[parry2k]

@Anonymous do you need by term period or month of the term period, it is bit confusing. Can you put sample data in excel file and also the output you want, otherwise we will keep on going in circles

[Anonymous]

@parry2k 

I need according to term period. Which you are seeing in the image it says no of EE_Id for FY19 OCT  and so on . 

The table visuals says count od EE_ID for each Term Period. 

I have count and I have to do sum for each Term Period.

[Anonymous]

In the above image it is count if ee_id . I just drag and droped into table and after that I just draged and droped term period and per particular month ee_id count . Here my out put should be sum of the count for each term period .