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
amitchandak's avatar
amitchandak
Super User
5 years ago

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

 

In case you need a measure try like

 

Running Total =
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

    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?

         

         

    • AllisonKennedy's avatar
      AllisonKennedy
      Community Champion
      5 years ago

      Anonymous If I am understanding you, you are looking for percent completed first time, not running total. 

       

      You cannot do this with the show values as. You will need to create a new measure: 

       

      Percent First Time = DIVIDE( COUNT( 'MyWorkList Case'[First Time Fix]) , COUNT( 'MyWorkList Case'[ID] ) )

       

      Format it as a percent (You don't need to multiply by 100). 

       

      Then add this to the matrix visual in your screenshot. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi kallie, thanks for this, but when I add it as an additional column, I get ann error with my visual.