Forum Discussion
Running Totals Based Upon Teams In Data
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])))
)
Sorry, is this per team - First Time Fix / ID * 100?
Its cause its not giving me that, or am I doing something wrong?
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.
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?
Hi Anonymous ,
Sorry for that I have trouble getting your pbix file.
Please provide me with more details about your table and your problem.
Best Regards,Eyelyn Qin