Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Divided Running total without names

Hello. I am new to power BI. I am trying to include a Line in my line Chart that adds up the total of all Workers and Divides them by Worker number so that I can see how much each worker should have...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could remove the legend fields. Then create measures for each Name and create a average measure.

    Put these measures in "Values".

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

I think your best bet would be a line and clustered column chart.  That would let you split the people out in the bars and keep the average running total as the line.  You can plan with the formatting too to get close to what you want maybe.  Also, you can divide by the DISTINCTOUNT() of the Name column instead of hard coding it with 4.   That way if you slice it by Name, you will get the right dynamic number.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi. Thank you for the answer. I will get to try it once I have the time.
    As for the DISTINCTCOUNT() it didnt work as in my measure it looked up the distinctcount for each month only and not total. So at some months where just 3 workers went it got divided by 3 instead of 4.
    But I will look into making it dynamic.