Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Running Totals Based Upon Teams In Data

Hi, I'm trying to get running totals based upon teams, so, what I mean is, how many calls a team has got where the value is a count. This needs to be a count of ID based upon a team, then the process...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

It seems like you want to calculate the count number based on group, right?

You could use the following formula:

Measure =
CALCULATE (
    DIVIDE (
        COUNT ( 'MyWorkList Case'[Id] ),
        COUNT ( 'MyWorkList Case'[First Time Fix] )
    ),
    FILTER (
        'MyWorkList Case',
        'MyWorkList Case'[ICT Teams] = MAX ( 'MyWorkList Case'[ICT Teams] )
    )
)
Column =
CALCULATE (
    DIVIDE (
        COUNT ( 'MyWorkList Case'[Id] ),
        COUNT ( 'MyWorkList Case'[First Time Fix] )
    ),
    ALLEXCEPT ( 'MyWorkList Case', 'MyWorkList Case'[ICT Teams] )
)
Column 2 =
CALCULATE (
    DIVIDE (
        COUNT ( 'MyWorkList Case'[Id] ),
        COUNT ( 'MyWorkList Case'[First Time Fix] )
    ),
    FILTER (
        'MyWorkList Case',
        'MyWorkList Case'[ICT Teams] = EARLIER ( 'MyWorkList Case'[ICT Teams] )
    )
)

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous, thanks for this, but the figure I require is count of First Time Fix / Count of ID to get my percentage for all the teams. These figures need to be displayed per row per team as in the screenshot above.