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
Icon for Super User rankSuper 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

Here's link to test copy of Power BI file without sensitive data.

 

Power BI File 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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