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

Thanks, this is what the data looks like, I need running totals instead of the default ones so that I can get the percentage right.

 

As you can see from the image, when trying to get a percentage across the rows, this is what I get. If I try by columns, then it gives the following.

 

It needs to be from 'MyWorkList Case'[First Time Fix] / 'MyWorkList Case'[ID] * 100. ID needs to be total calculated by team as well as First Time Fix. Hope it makes sense?

 

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , if you need % of running total try like

 

Running Total % = Divide(CALCULATE(Count('MyWorkList Case'[Id]),allselected('MyWorkList Case')) ,
CALCULATE(
Count('MyWorkList Case'[Id]),
FILTER(
allselected('MyWorkList Case'),
'MyWorkList Case'[ICT Teams]=MAX('MyWorkList Case'[ICT Teams])
&& 'MyWorkList Case'[Id] <= MAX('MyWorkList Case'[Id])))
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Sorry, is this per team - First Time Fix / ID * 100?

    Its cause its not giving me that, or am I doing something wrong?

     

     

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous ,

      Divide(Count(Table[First Time Fix]), Count(Table[ID])) *100

       

      // *100 Is not needed you can mark it as % from measure tools

       

      if this did not work then

      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hello amitchandak, sorry, only started to use this forumn just before the Christmas break, can you tell me how I can upload some samle data for you (and others) to help me out with this?