Forum Discussion
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...
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.
Hi kallie, thanks for this, but when I add it as an additional column, I get ann error with my visual.